sql select 中套一个select 查询结果作为一个列值,如何实现答:select a.id,a.ItemName,a.ItemNumber,a.ItempArea,a.TotalPrices,a.SettlementPrice,b.name,c.shoukang from Item a,PMInfo b,(SELECT sum(innumber) shoukang,ItemNumber FROM ShouKuang group by ItemNumber)c where a.ItemNumber=b.ItemNumber and a.ItemNumber=c.ItemNumber;