select
    S.SALES_DATE AS SAL_DATE,
    S.SALES_NO as NO,
    DTL.ITEM_CODE as ITEM_CODE,
    DTL.SALES_QTY as SAL_QTY,
    DELIVERED_QTY as DEL_QTY,
    CASE
	    WHEN DELIVERED_QTY=0
	    THEN '未出荷'
	    WHEN DTL.SALES_QTY>DELIVERED_QTY
	    THEN '一部出荷'
	    WHEN DTL.SALES_QTY=DELIVERED_QTY
	    THEN '出荷済'
	 END AS SHIP_STS
        

FROM SALES_DTL AS DTL
LEFT JOIN SALES AS S
    on S.SALES_NO = DTL.SALES_NO

ORDER BY 
	SAL_DATE DESC,NO ASC,ITEM_CODE ASC