Data from 2 tables

[hiteshkataria]

Hi,

There are 2 tables Tab1 & Tab2 with the below data:

Tab1:

Name	Cost
A1	5
B2	1
A1	8
C3	5
A1	7
A1	8
A1	5
B2	3
B2	3
C3	1

Tab2:

Name	Cost
A1	15
B2	11
A1	18
C3	15
A1	17
A1	18
A1	15
B2	13
B2	13
C3	11

I need to get Sum of Cost from both tables for a Name, i.e. the output should be as below:

Name	SumCost
A1	116
B2	44
C3	32

For A1 = 116:
"Sum of Cost from tab1 - 33" + "Sum of Cost from tab1 - 83"

Please suggest.

[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;

[hiteshkataria]

Thank you, so much!!!

[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;