delete
from orders
left outer join orders_dtl
on orders.order_no = orders_dtl.order_no
where 
orders.order_date between '2010-01-01' and '2010-12-31'