Deleting combined records from Access table

[txlongorn]

I have two tables that are joined by item numbers. I want Table A to
have items numbers that are not in Table B. How can I create a query
that will delete all records from Table A that are in Table B?

 

[John W. Vinson]

I have two tables that are joined by item numbers. I want Table A to
have items numbers that are not in Table B. How can I create a query
that will delete all records from Table A that are in Table B?

DELETE TableA.*
FROM TableA INNER JOIN TableB
ON TableA.itemnumber = TableB.itemnumber;

Back up your database first of course!! Deletion is irreversible.

John W. Vinson [MVP]