It is impossible because the Comparison Operator IN compare one expression
to another. It is true to ANSI SQL
Joerg Leute <leute_at_itdesign.de> escribió en el mensaje de noticias
7fmrna$o4i$1_at_news.LF.net...
> 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 Thu Apr 22 1999 - 20:42:15 CDT
