生产计划数量汇总表

五六零网校小于 1 分钟

代码示例

SELECT T0.[ItemCode], T1.[ItemName], SUM(T0.[PlannedQty]) AS '总计划数量', T1.[InvntryUom]
FROM OWOR T0
	INNER JOIN OITM T1 ON T0.itemcode = t1.itemcode
WHERE T0.[PostDate] >= [%0]
	AND T0.[PostDate] <= [%1]
GROUP BY T0.[ItemCode], T1.[ItemName], T1.[InvntryUom]
ORDER BY T0.[ItemCode]