Problem Deleting

[Raj]

DELETE [oldAcct].[Account Number], [tbl_FE to Prod].*
FROM [oldGov Acct] INNER JOIN [tbl_FE to Prod] ON
[oldAct].[Account Number] = [tbl_FE to
Prod].customer_account
WHERE (([account number]=[customer_account]));

 

[Dale Fye]

Raj,

Why don't you just build a relationship between these two
tables, set referential Integrity, and select cascading
deletes?

This would be much simpler!

HTH
Dale