Data from 2 tables

[gandolf989]

It seems like a simple enough query.
What is the issue?

select name, sum(value)
  from ( select name, value
           from tab1
          union all
         select name, value
           from tab1 )
 group by name
 order by name;