Re: NOT EXIST clause

OR use a correlated sub-query where pk is primary key: select * from test:a where NOT EXIST (select 'X' from live:b where test:a.pk = live:b.pk) Greg Try NOT IN with a common field. Your common field should be indexed. select * from test:a where commonfield not in (select commonfield from live:b)I do this all the time and it works for me. Be seeing you, -DAN >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.