query

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top