Unmatched Query of two different Tables

[jjc3397]

I need to perform an unmatched query to find data in one table that is not in another.

Table A contains

StoreCode StoreNumber Bottles
e5060 001 12
f6700 002 6

Table B contains

StoreCode StoreNumber Bottles
e5060 002 12
f6700 003 12

What would be the Jet Sequel Code to do this?

jjc3397

 

[Remou]

There is a Find Umatched Query wizard which will generate SQL for you.

 

[PHV]

Furthermore, what would be the expected result with the samples you've posted ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886