delete from ORDERS_DTL where exists(
    select * 
      from ORDERS
     where ORDER_DATE between '2010-01-01' and '2010-12-31'
       and ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
 );

delete from ORDERS where ORDER_DATE between '2010-01-01' and '2010-12-31';