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) If I do: Delete from units where claimno in (SELECT claimno FROM mainlist), then it correctly deletes the matches, leaving the 255 that don't match. Any ideas? VFP9, and I did alltrim claimno in both files, to be sure there were no padding issues. _______________________________________________ Post Messages to: [email protected] 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.
