Sum of two table value in one table

[Anonymous]

Hello Guys,

I have query that,

Table1   Table2

a b  c   a  c  e

a 1 3    l   5  9

b 2 4    m  6  4

c 3 5    n   8   3

Op/ will be,

Table3

a  c

a  6

b 8

c  11

Kindly help

[Kushal_Chawda]

Please explain the logic to get the output?

[Anonymous]

Are you perhaps trying to Concatenate or join the tables before using Sum?