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"));