select
		G.SALES_DATE		as SAL_DATE,
		G.SALES_NO		as NO,
		M.ITEM_CODE 	as ITEM_CODE,
		M.SALES_QTY		as SAL_QTY,
		M.DELIVERED_QTY	as DEL_QTY,
		CASE when M.DELIVERED_QTY = 0 then '未出荷'
			 when M.DELIVERED_QTY <> 0 and M.SALES_QTY > M.DELIVERED_QTY then '一部出荷'
			 when M.SALES_QTY = M.DELIVERED_QTY then '出荷済'
			 else NULL end		as  SHIP_STS
from
		SALES G
		inner Join SALES_DTL M  on (M.SALES_NO = G.SALES_NO)
where
		G.SALES_DATE between '2024-04-01' and '2024-04-10'
order by
		G.SALES_DATE desc,
		G.SALES_NO asc,
		M.ITEM_CODE asc