Vince Teachout wrote: > Any ideas as to why the following query returns no rows? > > SELECT claimno FROM units WHERE claimno NOT in (SELECT claimno FROM > mainlist) > > Claimno in both files is C(8), I can manually look up '07851' in Units > and find it, and manually look it up in mainlist and not find it. > (among others) > The problem turned out to be that one of the Claimnos in ClmMast was NULL. Removing it solved the problem. WHY it caused a problem, I don't know, and why it DIDN'T cause a problem with the same SELECT without the NOT keyword beats me.
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.