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';