SELECT a.SALES_DATE as SAL_DATE, b.SALES_NO as NO, b.ITEM_CODE as ITEM_CODE, b.SALES_QTY as SAL_QTY, b.DELIVERED_QTY as DEL_QTY,
    CASE
        WHEN b.DELIVERED_QTY = '0' THEN '未出荷'
        WHEN b.SALES_QTY > b.DELIVERED_QTY THEN  '一部出荷'
        WHEN b.SALES_QTY = b.DELIVERED_QTY THEN  '出荷済'
        END  as SHIP_STS
FROM SALES a,SALES_DTL b
WHERE a.SALES_NO =b.SALES_NO
ORDER by a.SALES_DATE desc,b.SALES_NO asc,b.ITEM_CODE asc;