Question

将2个表的数据汇总后插入到新表中，即表1中包含A和B字段，表2中包含A和C字段，汇总成A+B+C，得出B+C的合计

表1 数据(A值不唯一)
A B
1 5
2 3
1 2
3 6
表2数据(A值不唯一)
A C
1 3
3 1
4 5
合并后
A B C D
1 7(5+2) 3 10(B+C)
2 3 0 3
3 6 1 7

Answer 1

参考答案: 重复是学习之母。——狄慈根

Answer 2

select t1.*,t2.c,t1.b+t2.c as d from
(select a,SUM(B) AS B
FROM 表1
group by a) t1
inner join
(SELECT A ,SUM(C) AS C
FROM 表2
group by a) t2 on t1.a=t2.a