delete from orders_dtl
where 
    orders_dtl.order_no in (
        select 
            orders.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';