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