查询报表：物料成本为0的库存清单

SELECT T1.[ItemCode], T1.[ItemName], T0.[WhsCode], T0.[OnHand], T0.[AvgPrice]
FROM OITW T0
	INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode]
WHERE T0.[AvgPrice] = '0'
	AND T0.[OnHand] > 0
ORDER BY T0.[ItemCode], T0.[WhsCode]

五六零

海报 链接