DELETE query

[dollygg]

This query didn't work, any thought on this?

DELETE * FROM [Custodian Comparison Explanation] WHERE (([Custodian Comparison Explanation].ID NOT IN (SELECT ID From [Batch Custodian Reconciliations])));

[ConneXionLost]

Hi,

Try specifying an outer join between your tables instead of using IN.

Cheers,