请问这句SQL语句为什么报错

select 产品ID,SUM(数量),SUM(金额) from
(SELECT 产品ID, sum(数量) AS 数量, sum(金额) AS 金额
FROM 生产入库单详情 AS a
WHERE 入库单号 IN
(SELECT 入库单号
FROM 生产入库单
WHERE 审核 = 1)
GROUP BY 产品ID
UNION ALL
SELECT 产品ID, sum(数量) AS 数量, sum(金额) AS 金额
FROM 采购入库单详情 AS a
WHERE 入库单号 IN
(SELECT 入库单号
FROM 采购入库单
WHERE 审核 = 1)
GROUP BY 产品ID)
group by 产品ID