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