[RBASE-L] - SQL help

[Fogelson, Steve]

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