delete 
from ORDERS
join orders_dtl on orders.order_no = orders_dtl.order_no
where orders.order_date >= '2010-01-01' and orders.order_date <= '2010-12-31';

select orders_dtl,orders_dtl
from orders
join orders_dtl on orders.order_no = orders_dtl.order_no;