delete 
from orders_dtl
where orders_dtl.order_no in (
select 
orders.order_no
from orders
where
orders.order_date between '2010-01-01' and '2010-12-31'
)
;
delete 
from orders
where
orders.order_date between '2010-01-01' and '2010-12-31'
;