Re: WHERE IN query

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)
>

No - how would I (or the rdbms) need to read this? Is this an AND or an OR - what about
NULLS for ID or NAME?
use the AND, OR and outer joins to resolve all that --
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046