SELECT a.SALES_DATE AS SAL_DATE,a.SALES_NO AS NO,ITEM_CODE,SALES_QTY AS SAL_QTY, DELIVERED_QTY AS DEL_QTY,
CASE WHEN DELIVERED_QTY = 0 THEN "未出荷" 
     WHEN SALES_QTY = DELIVERED_QTY THEN "出荷済" ELSE "一部出荷" END AS SHIP_STS
FROM SALES_DTL
JOIN SALES AS a ON a.SALES_NO=SALES_DTL.SALES_NO
ORDER BY a.SALES_DATE DESC,a.SALES_NO,ITEM_CODE