I use Access 2010.
I have two tables and I want to delete all records from one table that correspond with the second table.
The select query of the records that I want to delete is:
FROM TblOrdersHeader INNER JOIN tblDeleteOrdersHeaderForSe
ON TblOrdersHeader.OrderID = tblDeleteOrdersHeaderForSe
In the query builder it looks like here:
The result from the select query is like
I do not manage to make a working delete query. Will you help please.