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.DELIVERED_QTY = d.SALES_QTY THEN '出荷済'
    ELSE '一部出荷'
END AS SHIP_STS
FROM SALES as s
INNER JOIN SALES_DTL as d ON s.SALES_NO = d.SALES_NO
WHERE '2024-04-01' <= s.SALES_DATE and s.SALES_DATE <= '2024-04-10'
ORDER BY s.SALES_DATE DESC, d.SALES_NO ASC, d.ITEM_CODE	ASC