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.