SELECT SALES.SALES_DATE as "SAL_DATE", SALES.SALES_NO as "NO", dtl.ITEM_CODE as "ITEM_CODE", dtl.SALES_QTY as "SAL_QTY", dtl.DELIVERED_QTY as "DEL_QTY",
CASE
WHEN dtl.DELIVERED_QTY=0 THEN "未出荷"
WHEN dtl.SALES_QTY>dtl.DELIVERED_QTY then "一部出荷"
ELSE "出荷済"
end as "SHIP_STS"
FROM SALES
LEFT OUTER JOIN SALES_DTL as dtl on SALES.SALES_NO=dtl.SALES_NO
WHERE "2024-04-01"<=SALES.SALES_DATE and SALES.SALES_DATE<="2024-04-10"
ORDER BY SALES.SALES_DATE DESC, SALES.SALES_NO, dtl.ITEM_CODE