SELECT T0.[OrigItem], T0.[AltItem], T0.[Match],Ts.[WhsCode] AS'备选物料仓库', Ts.[OnHand] AS'备选物料库存数量' FROM OALI T0
LEFT JOIN
(
SELECT T0.[ItemCode], T0.[WhsCode], T0.[OnHand] FROM OITW T0
) Ts ON TS.[ItemCode]=T0.[AltItem]
WHERE T0.[OrigItem]=$[ORCM.ITEMCODE]声明：欢迎来到五六零学院。
