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