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