Delete query with criteria from another table

[FuelingAround]

I have the following SQL statement which under a select statement works great. The issue is I just want to use the status field as a criteria on what to delete from the sp_excpt_cust table. Can someone point me in the right direction here?



DELETE ssfactor_sp_excpt_cust.ce_cust, ssfactor_sp_excpt_cust.ce_prodlnk, ssfactor_sp_excpt_cust.ce_lvl, ssfactor_ar_customer.cust_status
FROM ssfactor_sp_excpt_cust INNER JOIN ssfactor_ar_customer ON ssfactor_sp_excpt_cust.ce_cust = ssfactor_ar_customer.cust_customer
WHERE (((ssfactor_ar_customer.cust_status)="CL"));

[June7]

Deleting records should be a rare occurrence. Why do you want to delete?

No need to specify fields in a DELETE action as the entire record is removed.

DELETE FROM ssfactor_sp_excpt_cust WHERE ce_cust IN (SELECT ce_cust FROM ssfactor_ar_customer WHERE status="CL")

[FuelingAround]

sp table holds customer rebate amounts. I want to delete all records for customers who are no longer active so we have a smaller piece of data to manage. It doesn't effect any historical data as the system refers to the table when it makes a sale to that customer.

[June7]

The records could be filtered.

You don't care about history of rebates?

Did you try the suggested query?