SELECT
s.SALES_DATE AS SAL_DATE,
s.SALES_NO AS NO,
sd.ITEM_CODE AS ITEM_CODE,
sd.SALES_QTY AS SAL_QTY,
sd.DELIVERED_QTY AS DEL_QTY,
CASE 
WHEN sd.DELIVERED_QTY = 0 THEN '未出荷'
WHEN sd.DELIVERED_QTY <> 0 AND sd.SALES_QTY > sd.DELIVERED_QTY THEN  '一部出荷'
WHEN sd.DELIVERED_QTY = sd.SALES_QTY THEN '出荷済'
ELSE ''
END AS SHIP_STS
FROM
SALES s
LEFT JOIN SALES_DTL sd ON s.SALES_NO = sd.SALES_NO
WHERE
SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY s.SALES_DATE DESC,s.SALES_NO ASC,sd.ITEM_CODE ASC