Delete Query deleting more records than Subquery Returns

[Pisteuo]

The following Delete Query is deleting all records, but I need it to delete only records returned by the subquery.

The subquery correctly returns records when I test it without the Delete operation. Could I be implementing the Delete Query incorrectly?

DELETE tblCheck.fldPrimary
FROM tblCheck
WHERE EXISTS (SELECT tblCheck.fldPrimary, tblCheck.fldPkg, tblCheck.fldAuditDate
FROM tblCheck INNER JOIN tblImportCheck ON (tblCheck.fldPkg=tblImportCheck.fldPkg AND tblCheck.fldAuditDate=tblImportCheck.fldAuditDate));

Thank you.

 

[jdraw]

What do you think this part of your sql will do?

DELETE tblCheck.fldPrimary
FROM tblCheck

Here is more info on DELETE with EXISTS
http://www.techonthenet.com/sql/exists.php

Did you test your subquery to see what records would be affected?