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**** > > ** ** >
