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'