要一张物料信息表,显示的列有: 物料号,物料名,价格清单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