select x.name,sum(x.data) as num from ( select name,data from a union all select name,data from b ) x group by x.name order by num
select name, sum(data) from (select * from A union all select * from B)C group by name order by sum(data)
select c.name, sum(c.data) from (select * from A union all select * from B) c group by c.name order by sum(c.data)
select name, sum(data) from ( select name, sum(data) as data from A union all select name, sum(data) as data from B union all ) t group by name order by sum(data)
select name, sum(data) from ( select name, sum(data) as data from A union all select name, sum(data) as data from B ) t group by name order by sum(data)
select name,data from a
union all
select name,data from b
) x group by x.name order by num
(select * from A
union all
select * from B)C group by name order by sum(data)
(select * from A
union all
select * from B) c
group by c.name order by sum(c.data)
(
select name, sum(data) as data from A union all
select name, sum(data) as data from B union all
)
t
group by name order by sum(data)
(
select name, sum(data) as data from A union all
select name, sum(data) as data from B
)
t
group by name order by sum(data)