NEWBIE HERE...Two tables.. want to delete duplicates between them

[marydoyle9]

I think this is an easy one...

I have two tables - one is a Master. I want to delete the records in the Master if they are in the second table. Here's my SQL and I can't get it to work:

DELETE from TestMaster
INNER JOIN on JoinedDupList
ON TestMaster.ID=JoinedDupList.ID
WHERE JoinedDupList.ID = TestMaster.ID

I'm being told I need to define the table to delete from... I thought I defined it.

Thanks!

 

[EMP]

DELETE *
from TestMaster
where ID in (Select ID from JoinedDupList)

^

 

[marydoyle9]

Worked like a charm... THANKS!!!!!!!