DELETE t1
FROM TABLE1 t1
    INNER JOIN TABLE2 t2
        ON t1.ID = t2.ID

DELETE o
FROM ORDERS o
    INNER JOIN Clients c
        ON o.ClientID = c.ID
WHERE c.CreditHold = 1;