One would think that this would be a fairly common task. If there are any records in Table A whose id is on the "kill list" (Table B), delete that record.
So, for example:
DELETE *
FROM Table_A
WHERE Table_A.ID = Table_B_List_of_bogus_records.ID;
I'm attempting this query on Access, so it may not be a SQL problem. Access views "Table_B_List_of_bogus_records.ID" as a parameter needing input.
Any ideas?
Much appreciated.