SELECT T0.[ItemCode], T0.[ItemName], T0.[Price], T0.[Quantity] AS 数量, 
T0.[WhsCode]
	, T1.[WhsName]
FROM IQI1 T0
	INNER JOIN OWHS T1 ON T0.[WhsCode] = T1.[WhsCode]
WHERE T1.[WhsName] = [%0]

发表回复

后才能评论