DELETE FROM ORDERS
WHERE
ORDER_DATE between '2010-01-01' and '2010-12-31'
;
DELETE FROM ORDERS_DTL
WHERE
ORDER_NO IN
(
SELECT
1
FROM
ORDERS O
WHERE
O.ORDER_NO = ORDER_NO AND
ORDER_DATE between '2010-01-01' and '2010-12-31'
)