select name,sum(a) as a,sum(b) as b,sum(c) as c,sum(d) as d,sum(e) as e from (select name, a, b, c, d, e from table1 union all select name, a1, b1 c1 d1 e1 from table2 ) aa group by name
select name,sum(a),sum(b),sum(c),sum(d),sum(e) from( select * from table1 union all select * from table2) group by name
(select name, a, b, c, d, e from table1
union all
select name, a1, b1 c1 d1 e1 from table2
) aa
group by name
from(
select * from table1
union all
select * from table2)
group by name