DELETE FROM ORDERS_DTL AS DTL
WHERE EXISTS (
SELECT
	*
FROM ORDERS AS ORD
WHERE ORD.ORDER_NO = DTL.ORDER_NO
AND ORD.ORDER_DATE >= '2010-01-01'
AND ORD.ORDER_DATE <= '2010-12-31'
);

DELETE FROM ORDERS AS ORD
WHERE ORD.ORDER_DATE >= '2010-01-01'
AND ORD.ORDER_DATE <= '2010-12-31'
;