query

G

Guest

I have 2 tables A and B with Customer ID as a common
field. A has 10 records of which 5 are common to B too.
I would like to see the records from A that are not in B.

Thanks
 
F

fredg

I have 2 tables A and B with Customer ID as a common
field. A has 10 records of which 5 are common to B too.
I would like to see the records from A that are not in B.

Thanks
Click to expand...

Create a New Query.
Select the "Find unmatched Query Wizard" from the opening dialog box.
 
Top