Re: Query Not working with SE 5.05 ?

Just a guess, but maybe you have null values in mainid in subfile? The clause: where mainid not in (select mainid from subfile) will test false if any value of subfile.mainid is null. I don't actually remember one, but there may have been a bug in 4.10 where this did not test false. June stephen.mcs@ukonline.co.uk wrote: > This pice of sql works OK using SE 4.10 but does not work under SE 5.02 > > can anyone tell me why? It should return all entries in mainfile who do > > not have an entry in subfile but return nothing using 5.02 ?? > > select mainid from mainfile> > where mainid not in (select mainid from subfile)