FW: difference nested select union
----------
From: Charles Smith[SMTP:csmith@vsol.com]
Sent: Saturday, October 05, 1996 3:55 PM
To: 'Dennis Robinson'
Subject: FW: difference nested select union
Dennis:
The first select is finding all records from table a where the id column IS NOT IN
table b.
The second select is finding all records in a (id), and only the id_name
from b where the id in a = the id in b.
Not knowing the full table layout, and what he wants to accomplish, I hope this
answers your question?
Charles
----------
From: Dennis Robinson[SMTP:drrobin@vsol.com]
Sent: Friday, October 04, 1996 5:26 PM
To: 'Charles Smith'
Subject: FW: difference nested select union
----------
From: Bryan Tonnet[SMTP:wgtonb@sydsun.itsyd.bhp.com.au]
Sent: Friday, October 04, 1996 12:43 AM
To: informix-list@rmy.emory.edu
Subject: Re: difference nested select union
Jason Wickline wrote:
>
> I am unsure why I am getting different results from the following:
> select id
> from a
> where id not in (select id
> from b)>
> and
> select a.id, b.id name
> from a, outer b
> where a.id = b.id>
I think these 2 should be different, shouldn't they? The first one selects
a.id's which are not in b, and the second one selects a.id's that are in b.
Was there a typo in your original post, or just a brain warp on the syntax
(happens to everyone, I get at least 4 a day).
Bryan Tonnet
batonnet@zeta.org.au