SELECT T1.SALES_DATE AS SAL_DATE,T1.ORDER_NO AS NO, T2.ITEM_CODE AS ITEM_CODE, T2.SALES_QTY AS SAL_QTY, T2.DELIVERED_QTY AS DEL_QTY , CASE DEL_QTY  WHEN  0 THEN '未出荷' WHEN DEL_QTY < SALES_QTY THEN '一部出荷' WHEN DEL_QTY = SALES_QTY THEN '出荷済' END AS 'SHIP_STS' FROM SALES AS T1 LEFT OUTER JOIN SALES_DTL AS T2 ON T1.SALES_NO = T2.SALES_NO ORDER BY SAl_DATE DESC,NO ASC,ITEM_CODE ASC;