|
|
|
|
 |
|
복이 / 2001-01-30 / 오후 11:01:12 / 211.194.105.100
조회수 : 123
|
| [질문] 고쳤는뎅... ^^;;
|
sql = " Select a.title2 FROM love2 a "
sql = sql & " WHERE a.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select b.title2 FROM love b "
sql = sql & " WHERE b.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select c.title2 FROM jin c "
sql = sql & " WHERE c.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = " Select d.title2 FROM akross d "
sql = sql & " WHERE d.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select e.title2 FROM akross2 e "
sql = sql & " WHERE e.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select f.title2 FROM akross3 f "
sql = sql & " WHERE f.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = " Select g.title2 FROM akross4 g "
sql = sql & " WHERE g.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select h.title2 FROM akross5 h "
sql = sql & " WHERE h.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select i.title2 FROM akross6 i "
sql = sql & " WHERE i.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select j.title2 FROM akross7 j "
sql = sql & " WHERE j.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select k.title2 FROM akross8 k "
sql = sql & " WHERE k.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = "Select l.title2 FROM akross9 l "
sql = sql & " WHERE l.title2 like '%" & keyword & "%' "
sql = sql & "Union "
sql = " Select m.title2 FROM akross10 m "
sql = sql & " WHERE m.title2 like '%" & keyword & "%' "
Set rs1 = DbCon.Execute(sql)
마지막 값만 맞으면 값이 나오거든요^^;;
어떻게 해야 할지....
|
|
|
|