Access 不支持将括号放在 UNION ALL 子句之前

SELECT 查询1.产品ID, Sum(查询1.数量之合计) AS 数量之合计之合计, 查询1.仓库
FROM (

(SELECT 入库单.产品ID, Sum(入库单.数量) AS 数量之合计, 入库单.仓库 FROM 入库单 GROUP BY 入库单.产品ID, 入库单.仓库)
UNION ALL
(SELECT 出库单.产品ID, Sum(出库单.数量)*-1 AS 数量之合计, 出库单.仓库 FROM 出库单 GROUP BY 出库单.产品ID, 出库单.仓库)
UNION ALL 
(SELECT 报废记录.产品ID, Sum(报废记录.报废数量)*-1 AS 数量之合计, 报废记录.仓库 FROM 报废记录 GROUP BY 报废记录.产品ID, 报废记录.仓库)

) as 查询1
GROUP BY 查询1.产品ID, 查询1.仓库;

SELECT 查询1.产品ID, Sum(查询1.数量之合计) AS 数量之合计之合计, 查询1.仓库
FROM
(
    SELECT 入库单.产品ID, Sum(入库单.数量) AS 数量之合计, 入库单.仓库    FROM 入库单    GROUP BY 入库单.产品ID, 入库单.仓库
    UNION ALL
    SELECT 出库单.产品ID, Sum(出库单.数量)*-1 AS 数量之合计, 出库单.仓库    FROM 出库单    GROUP BY 出库单.产品ID, 出库单.仓库
    UNION ALL
    SELECT 报废记录.产品ID, Sum(报废记录.报废数量)*-1 AS 数量之合计, 报废记录.仓库    FROM 报废记录    GROUP BY 报废记录.产品ID, 报废记录.仓库
) AS 查询1
GROUP BY 查询1.产品ID, 查询1.仓库;