Sum of two column values from two different tables

I want sum of two column values from two different tables, how can I do it using SQL?

Suppose, these are my two tables, Table 1

Id     amount      date

101    100         2018-09-03

102    200         2018-09-03

Table 2

ID      amount       Date

101     500           2018-09-03

I want the result as 

ID       amount     

101      600

Asked by:- RameshwarLate
: 12149 At:- 10/3/2018 11:08:31 AM
sql sql server

1 Answers
profileImage Answered by:- jaya

Suppose, you have two tables as shown below


Then you can execute the SQL query as below to get the total Amount of each row

select Id,sum(Amount) total
    select Id,Amount
    from TestTable1
    union all
    select Id,Amount
    from TestTable2
) t
group by Id



Note: You will need to update column names / table names, as per your database table name and column name.

It should work.

At:- 10/3/2018 2:56:43 PM Updated at:- 9/27/2022 7:39:08 AM

Login/Register to answer
Register directly by posting answer/details

Full Name *

Email *

By posting your answer you agree on privacy policy & terms of use