delete from ORDERS_DTL
where ORDER_NO in (
    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'
;