-- select * from ORDERS 
-- where 
-- ORDER_DATE >= '2010-01-01' and ORDER_DATE <= '2010-12-31'
-- -- 受注日(ORDER_DATE)が2010年1月1日から2010年12月31日までの受注データとそ
-- ;

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

delete from ORDERS
where ORDER_DATE >= '2010-01-01' and ORDER_DATE <= '2010-12-31';