Deleting combined records from Access table

  • Thread starter Thread starter txlongorn
  • Start date Start date
T

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?
 
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?
Click to expand...

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]
 
Back
Top