Re: difference nested select union

> select id > from a > where id not in (select id > select a.id, b.id name > from a, outer b > where a.id = b.id> > the count of the null name is not equal to the count of id in first > sql. Can a.id or b.id be null? Can you unload the results to a text file , sort them and do a diff on them? (After selecting the 2nd query into a temp table and selecting where name is null of course). That would tell you what the difference is and whether its a bug or not. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***