select
    SALES_DATE as SAL_DATE
    ,sa.SALES_NO as NO
    ,sad.ITEM_CODE
    ,sad.SALES_QTY as SAL_QTY
    ,sad.DELIVERED_QTY as DEL_QTY
    ,(case when DELIVERED_QTY = 0 then '未出荷'
     when SALES_QTY > DELIVERED_QTY then '一部出荷'
     when SALES_QTY = DELIVERED_QTY then'出荷済'
     else '' end
    )as SHIP_STS
from SALES sa
left join SALES_DTL sad
    on sa.SALES_NO = sad.SALES_NO
where SALES_DATE >= '2024-04-01'
and SALES_DATE <= '2024-04-10'
order by SALES_DATE desc,sa.SALES_NO,sad.ITEM_CODE