When trying to create a delete query using multiple tables (eg. delete all rows out of table 1 that have a field matching a field in table 2). I keep getting an error message saying - "Specify the table containing the records you want to delete". How can I create a query that performs this function?

Thanks for any help.

Delete
From tableA
where id IN (Select id from tableB)