How to exclude non-matching records btw 2 tables

M

MSA

I have 2 tables and found matching records btw the two now I would like to
just exclude the matched records from one of the tables.
e.g. Table A has 10 records and Table B has 5 records. These tables have 2
records that match, now I would like to exclude these two records from Table
A thereby having a result of 8 records. How can I do this in Access via
queries.
 
B

Brendan Reynolds

When you create a new query in Access, the New Query dialog box lists five
options. The fifth option is 'Find Unmatched Query Wizard"

If you want to do it manually, it looks something like this ...

SELECT TableB.*
FROM TableB LEFT JOIN TableA ON TableB.TableBNum = TableA.TableANum
WHERE (((TableA.TableANum) Is Null));
 
Top