Combining Records From Two Different Tables

[Nitin]

Here I need a help. I have two tables 1) Mis_A 2) Mis_B

Mis_A Mis_B


Location Revenue Location Sale
Mumbai 10 Mumbai 5
Mumbai 10 Chennai 10
Goa 5 Madras 10
Goa 5 Goa 5


I need an output in the Format shown below with sql query


Location Total(Revnue+Sale)
Mumbai 25
Goa 15
Chennai 10
Madras 10


Thanks in advance

 

[Allen Browne]

Answered in another group where you posted this question.