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