[RBASE-L] - Re: SQL help

[Dan Goldberg]

SELECT * FROM TableA where AProductCode not in (select BProductCode from TableB)

This will give you all the rows that are not in TableB 

Dan Goldberg


From: Fogelson, Steve 
Sent: Tuesday, March 27, 2012 9:31 AM
To: RBASE-L Mailing List 
Subject: [RBASE-L] - SQL help
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