Hi,

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

Code:
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:

Code:
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.