select SALES.SALES_DATE as SAL_DATE,SALES.SALES_NO as NO,ITEM_CODE as ITEM_CODE,SALES_QTY as SAL_QTY,DELIVERED_QTY as DEL_QTY,CASE SALES_DTL.SALES_QTY-SALES_DTL.DELIVERED_QTY WHEN 0 THEN '出荷済' WHEN SALES_DTL.SALES_QTY THEN '未出荷' ELSE '一部出荷' END as SHIP_STS from SALES, SALES_DTL where SALES.SALES_NO=SALES_DTL.SALES_NO and SALES.SALES_DATE between '2024-04-01' and '2024-04-10' order by SALES.SALES_DATE desc, SALES_DTL.SALES_NO, SALES_DTL.ITEM_CODE