This it appears to be simple but getting all the stars to align on the SQL query is proving to be a pain.
Basically, I have in Table1 a list all the IDs I want to delete out of Table2
The key field name in both tables is called ID. What I want to do is delete all the records from Table2 that are equal to the ID in Table 1.
I have done this in a delete query with a join with the below code but it is giving be the above error
FROM Tbl_ClientFlightControl INNER JOIN tbl_tmp_NotAsia_Clients ON Tbl_ClientFlightControl.ID = tbl_tmp_NotAsia_Clients.ID;
How do I fix the SQL code to get the desired results?