Re: NOT EXIST clause

Hi Terron, You need to add a WHERE clause to your subquery, otherwise if table live has any rows then they EXIST! Try: select * from test:a where NOT EXIST (select * from live:b where b.commonfield = a.commonfield) Good luck, Rob Terron Wright <twright@inbrand.com> wrote in article <5jleph$fg8@cssun.mathcs.emory.edu>... > I am using the NOT EXIST clause in a select statement and it appears to > not be working. I know that there is one record in table a that is not > in table b and I though that it would give me that one record. > > SQL > > select * from test:a where NOT EXIST > (select * from live:b)> > It returns with no records. I have noticed that this statement works on > a table with less records in it. Does someone have a solution. >