Re: Minor SQL SELECT anomoly

Hi Bill,
My bet is that you're selecting a column that exist in the driving table but does not exist in the IN (subselect?). That's not illigal - and you'll see that Oracle does not consider your IN query an independed - but as a semijoin.

Regards
Peter H. Larsen (petlars_at_pip.dknet.dk) Oracle Consultant (not affiliated with Oracle)

On 8 Dec 1997 22:35:37 GMT, "Bill" <billirv_at_flash.net> wrote:

>
>I'm using 7.1 Oracle on VMS. I am doing a SELECT statement with a WHERE IN
>clause containing a second SELECT statement. The SELECT in the WHERE
>clause has an invalid column name, so I would expect to get an invalid
>column name error. Instead the SELECT completes successfully with zero
>rows returned.
>
>I think the SELECT should return an error. Please post any responses to
>the newsgroup.
>
>Thanks,
>
>Bill
Received on Wed Dec 10 1997 - 00:00:00 CET