Access 的 SQL 中,计算相应编号的记录之间 加 减 的查询命令
例如 计算ID为 6 的 合计 减去 ID 为 2、3、4 以及加上 ID 为 5 的合计
SELECT SUM(R) AS 结果
FROM
(
SELECT 合计 AS R FROM T1 WHERE (ID = 6) UNION
SELECT -合计 AS R FROM T1 WHERE (ID = 2) UNION
SELECT -合计 AS R FROM T1 WHERE (ID = 3) UNION
SELECT -合计 AS R FROM T1 WHERE (ID = 4) UNION
SELECT 合计 AS R FROM T1 WHERE (ID = 5)
) T