Re: WHERE IN query

Yep, I stand corrected.
Thomas already pointed it out.

Thanks - I learned from it

James wrote:

> Response is in line.
> In article <371F0F79.BDAEC959_at_vnl.nl>,
> Frank van Bortel <f.van.bortel_at_vnl.nl> wrote:
> > 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 -
>
> The parens present the columns as a single value, it is an AND condition. IE
> "WHERE (id and name) are IN (SELECT ID-2 and NAME_2 FROM TABLE2)" Both must
> match to return a record.
>
> > what about
> > NULLS for ID or NAME?
>
> NULLS are treated as NULLS, unknown, not equal to anything, even another NULL
> and not unequal to anything.
>
> > 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
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

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