将两个价格清单放在一行显示 沧海

要一张物料信息表,显示的列有:物料号,物料名,价格清单01,价格清单02.
解决办法：运用表的连接关系，写SQL语句如下：

SELECT TOP 100 PERCENT T0.ItemCode, T0.ItemName, T1.Price AS price1,T2.Price AS price2
FROM dbo.OITM T0 INNER JOIN
      dbo.ITM1 T1 ON T0.ItemCode = T1.ItemCode INNER JOIN
      dbo.ITM1 T2 ON T0.ItemCode = T2.ItemCode
WHERE (T1.PriceList = '1') AND (T2.PriceList = '2')
ORDER BY T0.ItemCode