解决办法:运用表的连接关系,写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