Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: WHERE IN - Query
Which Oracle version are you using, I tried with Oracle8, and it's working
fine.
Thanks,
Vrajesh Patel.
Joerg Leute wrote:
> Hi everybody
>
> Isn't it possible to extend a WHERE IN query over 2 columns - first column
> is number and second is char) like
>
> SELECT * FROM TABLE1 WHERE (ID, NAME) IN (SELECT ID_2, NAME_2 FROM TABLE2)
>
> Thanks for your help
>
> Joerg
Received on Fri Apr 23 1999 - 14:38:07 CDT