DELETE od
FROM ORDERS_DTL AS od INNER JOIN ORDERS AS o 
    on o.ORDER_NO = od.ORDER_NO
WHERE o.ORDER_DATE BETWEEN '2010-01-01' AND '2010-12-31';