Thanks Bill and Dan
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Tuesday, March 27, 2012 11:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL help Steve, SELECT * FROM TableA t1 WHERE t1.AProductCode NOT IN (Select BPartCode FROM TableB t2) or SELECT * FROM TableA t1 WHERE NOT EXIST + (SELECT BID FROM TableB t2 WHERE t2.BProductCode = t1.AProductCode) Bill On Tue, Mar 27, 2012 at 12:31 PM, Fogelson, Steve <[email protected]> wrote: TableA AID AProduct Code Table B BID BProductCode I want to determine all the rows in table A that do not have a row in table B based on AProductCode and BProductCode I tried SELECT * FROM TableA t1, TableB t2 WHERE t1.AProductCode != t2.BPartCode LIMIT 1, 3000; Not even close Is there a quick solution to this? Thanks Steve Fogelson
