SELECT A1.[编号],A1.[数量],B1.[成分],A1.[价格]
FROM
(SELECT [编号],SUM([数量]) AS [数量],AVG(价格) AS [价格]
FROM [表A]
GROUP BY [编号]
) A1,
(SELECT DISTINCT [编号],成分 from [表A]) B1
WHERE A1.[编号]=B1.[编号]
ORDER BY [编号]
写掉了个FROM
最终想把表的内容整理成下面的格式
1 10 棉 100
2 5 毛 100
------------------------------------
SELECT A1.[编号],A1.[数量],B1.[成分],A1.[价格]
(SELECT [编号],SUM([数量]) AS [数量],AVG(价格) AS [价格]
FROM [表A]
GROUP BY [编号]
) A1,
(SELECT DISTINCT [编号],成分 from [表A]) B1
WHERE A1.[编号]=B1.[编号]
ORDER BY [编号]
------------------------------------
给分吧