DELETE ORDERS FROM ORDERS INNER JOIN ORDERS_DTL ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO WHERE ORDER_DATE >= '2010-01-01' AND ORDERS.ORDER_DATE <= '2010-12-31';
SELECT * FROM ORDERS;