select
SALES_DATE as SAL_DATE
,DTL.SALES_NO as NO
,ITEM_CODE as ITEM_CODE
,SALES_QTY as SAL_QTY
,DELIVERED_QTY as DEL_QTY
,case 
 when DELIVERED_QTY = 0  then '未出荷'
 when DELIVERED_QTY <> 0 and SALES_QTY > DELIVERED_QTY  then '一部出荷'
 when SALES_QTY = DELIVERED_QTY then '出荷済' 
 end as SHIP_STS
from 
SALES as SA
left join SALES_DTL as DTL
on SA.SALES_NO = DTL.SALES_NO

where 
SALES_DATE between '2024-04-01' and '2024-04-10'

order by 
SALES_DATE desc
,DTL.SALES_NO 
,ITEM_CODE desc