SELECT
        S.SALES_DATE AS 'SAL_DATE',
        S.SALES_NO AS 'NO',
        D.ITEM_CODE AS 'ITEM_CODE',
        D.SALES_QTY AS 'SAL_QTY',
        D.DELIVERED_QTY AS 'DEL_QTY',
        CASE WHEN D.DELIVERED_QTY = 0 THEN '未出荷'
             WHEN D.SALES_QTY > D.DELIVERED_QTY THEN '一部出荷'
             WHEN D.SALES_QTY = D.DELIVERED_QTY THEN '出荷済'
        END AS 'SHIP_STS'
FROM
        SALES AS S
        INNER JOIN
                SALES_DTL AS D
                ON S.SALES_NO = D.SALES_NO
ORDER BY
        S.SALES_DATE DESC,
        S.SALES_NO ASC,
        D.ITEM_CODE ASC;