Simple Delte Query not working

[Dougalsworld]

Hi Guys,

I've tried searching the forums for an answer with no joy.
I'm trying to create a very simple DELETE query, which I've never had an issue with before.

Basically I have two tables

Dbo_PDRPerson (PersonID, RoleID, PDRID)
tbl_InfoByPDR (PDRID)

Basically I want to delete all records in Dbo_PDRPerson where a corresponding PDRID record exists in tbl_InfoByPDR

My current method:

DELETE dbo_PDRPerson.PersonID, dbo_PDRPerson.RoleID, dbo_PDRPerson.PDRID
FROM dbo_PDRPerson INNER JOIN tbl_InfoByPDR ON dbo_PDRPerson.PDRID = tbl_InfoByPDR.PDRID;

This tells me to "Specify the table containing the records you want to delete"

Any ideas

Many thanks

 

[MStef]

Look at "demoDeleteqryPDRIDA2000.mdb",
Look at Tables (PDRID field, Indexed properties), (PDRID2 field, Indexed properties).
Look at Relationships, Query1.
Run Query1.

 

[Jacob Mathai]

DELETE * FROM dbo_PDRPerson where dbo_PDRPerson.PDRID in (select PRDID from tbl_InfoByPDR)