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