DELETE FROM ORDERS_DTL
WHERE ORDER_NO = (
    SELECT ODD.ORDER_NO
    FROM ORDERS_DTL as ODD
    JOIN ORDERS as OD
    ON ODD.ORDER_NO = OD.ORDER_NO
    WHERE OD.ORDER_DATE BETWEEN 2010-01-01 and 2010-12-31
)