Delete Query

[primagic]

I have the following select query which returns the correct results.

However, I now want to be able to delete these results from the School table. Basically it shows a list of all schools that have no engagements.

SELECT Engagement.EngagementID, School.SchoolID, School.SchoolName
FROM School LEFT JOIN Engagement ON School.SchoolID = Engagement.SchoolID
WHERE (((Engagement.EngagementID) Is Null))

I have tried the following sql for a delete statement but it says "specify the table containing the records you want to delete"

DELETE Engagement.EngagementID, Engagement.SchoolID, School.SchoolName
FROM School LEFT JOIN Engagement ON School.SchoolID = Engagement.SchoolID
WHERE (((Engagement.EngagementID) Is Null));

Help please

 

[PHV]

DELETE School.*
FROM School LEFT JOIN Engagement ON School.SchoolID = Engagement.SchoolID
WHERE (((Engagement.EngagementID) Is Null));

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886