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 T2.DELIVERED_QTY  WHEN T2.DELIVERED_QTY = 0 THEN '未出荷' WHEN T2.DELIVERED_QTY < T2.SALES_QTY THEN '一部出荷' WHEN T2.DELIVERED_QTY = T2.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;