DELETE FROM ORDERS WHERE ORDER_DATE  BETWEEN '2010-01-01' AND '2010-12-31';
SELECT * FROM ORDERS AS O
LEFT JOIN ORDERS_DTL AS DTL 
ON O.ORDER_NO = DTL.ORDER_NO;