Re: WHERE IN query

From: Patrick Suppes <psuppes_at_lucent.com>
Date: Thu, 22 Apr 1999 12:02:29 -0600
Message-ID: <371F6435.75942E7@lucent.com>

Anyone,

What are the advantages/disadvantages of the syntax

select * from table1

       where (id1, name1) in
            (select id2, name2 from table2)

compared to the syntax

select table1.* from table1, table2

      where id1 = id2
           and name = name2

Patrick Suppes

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 Thu Apr 22 1999 - 13:02:29 CDT