Re: NOT EXIST clause

In <c=US%a=_%p=Inbrand_Corporat%l=WINFRAME-970423161457Z-2078@mail.inbrand.com>, Terron Wright wrote: >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. There is probably a null being returned in the subquery which messes everything up . This is a bug in Informix as far as I'm concerned. Try eliminating any nulls that are returned. This is easier done by matching specific fields in the query rather than doing a Select *. Regards, Sean Birkhead Informations Solutions (Ire.) Ltd.