Problem Deleting

  • Thread starter Thread starter Raj
  • Start date Start date
R

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]));
 
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
 
Back
Top