小问题,救急
我有一句sql
SELECT 部门ID, 子类id, 大类id, SUM(物品数量) AS shuliang, 单价 * SUM(物品数量)
AS zongjia
FROM 物品保存表
WHERE (发放人ID = - 1) AND (领取时间 > '2003-1-1') AND (领取时间 < '2004-1-1')
GROUP BY 子类id, 大类id, 部门ID, 单价
ORDER BY 部门ID, 大类id, 子类id
直接运行正常,但要是改成
SELECT 部门ID, 大类id, SUM(shuliang) AS shu, SUM(zongjia) AS jia
FROM (SELECT 部门ID, 子类id, 大类id, SUM(物品数量) AS shuliang, 单价 * SUM(物品数量)
AS zongjia
FROM 物品保存表
WHERE (发放人ID = - 1) AND (领取时间 > '2003-1-1') AND (领取时间 < '2004-1-1')
GROUP BY 子类id, 大类id, 部门ID, 单价
ORDER BY 部门ID, 大类id, 子类id)
GROUP BY 大类id
就报错,改怎么修改呢?