|
|
|
|
 |
|
채영이 / 2001-01-30 / 오후 11:20:22 / 203.255.3.190
조회수 : 133
|
| [질문] 고쳤는뎅... ^^;;
|
> 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)
>
> 마지막 값만 맞으면 값이 나오거든요^^;;
>
> 어떻게 해야 할지....
>
>
-----------------------------------------------------------
sql = "Select b.title2 FROM love b "
이게 아니고
sql = sql & "Select b.title2 FROM love b "
이렇게 되야 되는거 아닌지... -_-
|
|
|
|