Delete with join query

[Pirre001]

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.

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

[GaryMazzone]

You need to delete each table individually. You can't delete two tables in one statement.

[Pirre001]

Ok, thanks for the answer. I believe it was possible.

So, If I should do this this individually, I must start with table tblCustDesc. How should the queries look lik then? Like this? Or do you have any other better solutions?

DELETE FROM tblCustDesc 
    WHERE state_ID IN ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK') 
    And Order_ID  IN  ( SELECT tblCust.ID FROM tblCust WHERE tblCust.StartedBy Is Null) 
    And Order_ID  IN  ( SELECT tblCust.ID FROM tblCust WHERE tblCust.state_ID = 
                      ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description = 'OK');
    
    'Execute the query
   

DELETE FROM tblCust
    WHERE state_ID IN ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK')
    And ID Not IN ( SELECT tblCustDesc.Order_ID FROM tblCustDesc WHERE state_ID IN
                  ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description <> 'OK')
    And tblCust.StartedBy Is Null;

'Execute the query

[GaryMazzone]

Last one is missing a close ) before the last And

[Pirre001]

OK, so this is the right way to do the delete query?

DELETE FROM tblCustDesc 
    WHERE state_ID IN ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK') 
    And Order_ID  IN  ( SELECT tblCust.ID FROM tblCust WHERE tblCust.StartedBy Is Null) 
    And Order_ID  IN  ( SELECT tblCust.ID FROM tblCust WHERE tblCust.state_ID = 
                      ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description = 'OK'));
    
    'Execute the query
   

DELETE FROM tblCust
    WHERE state_ID IN ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description='OK')
    And ID Not IN ( SELECT tblCustDesc.Order_ID FROM tblCustDesc WHERE state_ID IN
                  ( SELECT StateDef.ID FROM StateDef WHERE StateDef.Description <> 'OK'))
    And tblCust.StartedBy Is Null;

'Execute the query

[GaryMazzone]

That look good