CREATE TABLE #A
(
字段1 VARCHAR(10),
字段2 int
)
CREATE TABLE #B
(
字段1 VARCHAR(10),
字段2 int
)
INSERT INTO #A VALUES('A',1),('B',1),('C', 2)
INSERT INTO #B VALUES('A',1), ('C', 1)
--相加
SELECT 字段1,SUM(字段2) FROM
(
SELECT 字段1,字段2 FROM #A
UNION ALL
SELECT 字段1,字段2 FROM #B
) A GROUP BY 字段1
--相减
SELECT 字段1,SUM(字段2) FROM
(
SELECT 字段1,字段2 FROM #A
UNION ALL
SELECT 字段1,-字段2 FROM #B
) A GROUP BY 字段1 HAVING SUM(字段2)<>0
