select
SALES_DATE as SAL_DATE
,SA.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

order by 
SALES_DATE desc
,SA.SALES_NO 
,ITEM_CODE desc