sum 2 columns with equal names
 

hi

how can i sum 2 columns from 2 tables having in common the same names
by side of the numbers to sum?

table1
table2 table3

column1 column2 col1
col2 col1 col2

1 a 1
b a ? = tab1 col1+tab2
col1
2 b 2
c b ?
3 c 3
d c ?
4 d 4
a d ?
5 e 5
g f ?
6 f 6
i g ?
7 g 7
h h ?
8 h 8
e i ?
9 i 9
f j ?


thanks

sum 2 columns with equal names
 

On 20 Jan, 16:05, Luís Miguel Ramires Vieira Reis RAM
wrote:
hi

how can i sum 2 columns from 2 tables having in common the same names
by side of the numbers to sum?

hi

how can i sum 2 columns from 2 tables having in common the same names
by side of the numbers to sum?

table1

column1 column2

1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 i


table2


col1 col2
1 b
2 d
3 a
4 f
5 c
6 f
7 g
8 h



table3

col1 col2
a ? = tab1 col1+tab2 col1
b ?
c ?
d ?
e ?
f
g
h
i
j



thanks

thanks