delete from orders_dtl
left outer join orders
on orders_dtl.order_no = orders.order_no
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'
;