Data from 2 tables

[gandolf989]

Of course looking back, I see the classic cut paste error.
Your welcome.

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