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.delivered_qty <> 0 and sd.sales_qty > sd.delivered_qty then '一部出荷'
when sd.delivered_qty = sd.sales_qty then '出荷済'
end
as SHIP_STS
from sales as s
left 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 s.sales_date desc, s.sales_no asc, sd.item_code asc;