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