SELECT SALES_DATE AS 'SAL_DATE',SALES_NO AS 'NO',ITEM_CODE ,SALES_QTY AS 'SAL_QTY',DELIVERED_QTY AS 'DEL_QTY',
(SELECT DEL_QTY FROM SALES_DTL WHERE if DEL_QTY = 0 AS '未出荷',else if SALES_QTY > DELIVERED_QTY AS '一部出荷' else SALES_QTY = DELIVERED_QTY AS '出荷済み') AS 'SHIP_STS'
FROM SALES INSERT INTO SALES_DTL ON  SALES_NO.SALES = SALES_NO.SALES_DTL WHERE SALES_DATE BETWEEN ('2024'/'4'/'1') AND ('2024'/'4'/'10')
ORDER BY SALES_DATE DESC,SALES_NO ASC,ITEM_CODE ASC;