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