Delete Query

[jgelpi16]

My goal is this.

Users mark records to be deleted in one table. The records have a primary key field. What I want to do is delete all records in a second table where the users made the selection in the first table. Here is some "pseudo code" if you will.

Delete * from table2 where table2.ID = table1.ID and table1.Sel = Yes



When I try to run this code it says "Cannot Delete".

DELETE Table2.*, Table1.Exclude
FROM Table1 INNER JOIN Table2 ON Table1.PriEntityID = Table2.PriEntityID
WHERE (((Table1.Exclude)=Yes));

Any help will be much appreciated.

[weekend00]

delete distinctrow table1.*
FROM Table1 INNER JOIN Table2 ON Table1.PriEntityID = Table2.PriEntityID
WHERE (((Table1.Exclude)=Yes));

[jgelpi16]

Thank you!