select
s.sales_date as SAL_DATE,
s.sales_no as NO,
sd.item_code as ITEM_CODE,
sd.SALES_QTY as SAL_QTY,
sd.DELIVERED_QTY as DEL_QTY,
case when sd.DELIVERED_QTY = 0 then '未出荷' when sd.SALES_QTY > sd.DELIVERED_QTY then '一部出荷' else '出荷済' end as SHIP_STS
from
SALES as s
inner join SALES_DTL as sd
on
s.sales_no = sd.sales_no
where s.sales_date between '2024-04-01' and '2024-04-10'
order by SAL_DATE DESC, NO, ITEM_CODE