SELECT
	A.SALES_DATE				AS	SAL_DATE,
	A.SALES_NO					AS	NO,
	B.ITEM_CODE					AS	ITEM_CODE,
	B.SALES_QTY					AS	SAL_QTY,
	B.DELIVERED_QTY				AS	DEL_QTY,
	CASE	WHEN	B.DELIVERED_QTY	=	0	THEN	'未出荷'
			WHEN	B.DELIVERED_QTY	<>	0	AND	B.SALES_QTY	>	B.DELIVERED_QTY	THEN	'一部出荷'
			WHEN	B.SALES_QTY	=	B.DELIVERED_QTY	THEN	'出荷済'
	END                         AS  SHIP_STS
FROM
	SALES	A
	LEFT	JOIN	SALES_DTL	B
		ON	B.SALES_NO	=	A.SALES_NO
WHERE
	date(A.SALES_DATE)	>=	date('2024-04-01')
AND	date(A.SALES_DATE)	<=	date('2024-04-10')
ORDER	BY
	SAL_DATE	DESC
	,NO
	,ITEM_CODE
;