How to exclude non-matching records btw 2 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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));
 
Back
Top