delete from ORDERS_DTL where ORDERS_DTL.ORDER_NO in (select ORDER_NO from ORDERS where ORDER_DATE >= '2010-1-1' and ORDER_DATE <= '2010-12-31');
delete from ORDERS where ORDER_DATE >= '2010-1-1' and ORDER_DATE <= '2010-12-31';