DELETE FROM
	ORDERS_DTL AS B
WHERE
	B.ORDER_NO IN (SELECT ORDER_NO FROM ORDERS WHERE ORDER_DATE BETWEEN '2010-01-01' AND '2010-12-31');
DELETE FROM
	ORDERS AS A
WHERE
	A.ORDER_DATE BETWEEN '2010-01-01' AND '2010-12-31';