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';