I have a query I use to return rows from two tables with kriteries. But how can I convert this query to a delete query?
I wanna delete the result of this query on both tables.
I have try to replce SELECT tblCust.*, tblCustDesc.* with Delete tblCust, tblCustDesc without any luck.
Code:SELECT tblCust.*, tblCustDesc.* FROM tblCust INNER JOIN tblCustDesc ON tblCust.ID = tblCustDesc.Order_ID WHERE tblCustDesc.State_ID In (SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK') AND tblCust.State_ID In (SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK') AND tblCust.StartedBy Is Null




Reply With Quote