select H.SALES_DATE AS SAL_DATE
      ,H.SALES_NO AS NO
      ,D.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 <> 0 and D.SALES_QTY > D.DELIVERED_QTY  then '一部出荷'
        when D.SALES_QTY = D.DELIVERED_QTY  then '出荷済'
        end 
      ) as SHIP_STS
 from sales H
     ,SALES_DTL D
where H.SALES_NO = D.SALES_NO
 and (H.SALES_DATE >= '2024-04-01'
  and  H.SALES_DATE <= '2024-04-10')
order by H.SALES_DATE desc
        ,H.SALES_NO 
        , D.ITEM_CODE