DELETE t1, t2
FROM ORDERS AS t1
INNER JOIN ORDERS_DTL AS t2
ON t1.ORDER_NO = t2.ORDER_NO
WHERE
    ORDER_DATE BETWEEN '2010-01-01' AND '2010-12-31';