Re: WHERE IN query

From: James <james_lorenzen_at_allianzlife.com>
Date: Thu, 22 Apr 1999 12:43:58 GMT
Message-ID: <7fn5id$adc$1@nnrp1.dejanews.com>

That syntax should work. It depends on the version you are on, it works on 7.3.4, but it may not work on earlier versions.

James

In article <7fmrln$o4a$1_at_news.LF.net>,
"Joerg Leute" <leute_at_itdesign.de> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 07:43:58 CDT