DELETE 
    ORDERS, ORDERS_DTL
FROM 
    ORDERS
INNER JOIN ORDERS_DTL
    ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
WHERE   ORDER_DATE >= '2010-01-01' 
    AND ORDER_DATE <= '2010-12-31';

SELECT * FROM ORDERS;