Re: WHERE IN query

The 'standard form' should work on 7.3.2;

Is it possible that one of the columns in the subquery returns a null, thus failing every row in the main query ?

By the way - the concatenated form will eliminate some of the transformations
that Oracle could otherwise choose to
optimise your query, so it should be
avoided if possible.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Joerg Leute wrote in message <7fp5ru$m08$1_at_news.LF.net>...
>That was it! Since I have Version 7.3.2.2.1 the standard form did not work,
>but yours did.
>
>>
>>As all earlier persons were addressing the fact that it seems you want
both
>>fields to match may I suggest this instead.
>>
>>Select * from Table1 where ID||Name in (select ID2||Name2 from Table2)
>>
Received on Fri Apr 23 1999 - 12:46:30 CDT