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