Delete Query with Two Tables

Question

I'm trying to delete all the records in the GuardianAndContacts table where no related records exist in the Student_GuardianAndContacts table using the following query, however I get this error message: "Specify the table containing the records you want to delete".  

SELECT GuardiansAndContacts.*, Students_GuardiansAndContacts.ID

FROM GuardiansAndContacts LEFT JOIN Students_GuardiansAndContacts ON GuardiansAndContacts.ID = Students_GuardiansAndContacts.GuardianID

WHERE (((Students_GuardiansAndContacts.ID) Is Null));

Answer 1

Perhaps something like this:

DELETE * FROM GuardianAndContacts WHERE GuardianID NOT IN (SELECT DISTINCT GuardianID FROM Students_GuardianAndContacts)

That would remove all records from GuardianAndContacts where the GuardianID does not exist in Students_GuardianAndContacts.

Before trying out any Delete processes, be sure to make a backup of your database

Answer 2

Thanks, worked perfectly.