I need to make a query that will delete records as follows:
If [ID] exists in [Tbl2] then DELETE row from [Tbl1] WHERE [ID] is the same.
I have tried many variants on this but get errors saying:
"Specify the table containing the records you want to delete."
"Couldn't delete from specified tables"
I'm at a loss on this one. Please help!