库存查询报表-物料编码查询

五六零网校小于 1 分钟

代码示例

SELECT T0.[WhsCode], T2.[ItmsGrpNam], T0.[ItemCode], T1.[ItemName], T0.[OnHand]
FROM OITW T0
	INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode]
	INNER JOIN OITB T2 ON T1.[ItmsGrpCod] = T2.[ItmsGrpCod]
WHERE T0.[ItemCode] = [%0]
ORDER BY T2.[ItmsGrpNam], T0.[ItemCode]