query

Question

i hav a 3 tables 1> id amount 2>id amount 3>Id amount 1 100 1 100 1 100 2 200 2 200 2 200 3 300 3 300 4 400 output> id AMOUNT 1 300 2 600 3 600 4 400 let me know the answer any one? Please share with me

ali tuncer · Answer

you can union tables group by ID and get sum.. SELECT ID Sum(Amount) FROM (select IDAmount from Table1 union ALL select IDAmount from Table2 UNION ALL select IDAmount from Table3) GROUP BY ID

Shubham Kumar · Answer

Hi Here is the query how to do that Declare @table1 TABLE (Id INT  Valu int ) Declare @table2 TABLE (Id INT  Valu int ) Declare @table3 TABLE (Id INT  Valu int ) INSERT INTO @table1 VALUES (1100)(2200)(3300)(4500) INSERT INTO @table2 VALUES (1100)(2200) INSERT INTO @table3 VALUES (1100) SELECT [@table1].Id AS Id  ISNULL ([@table1].Valu0)+ ISNULL ([@table2].Valu0)+ ISNULL ([@table3].Valu0) AS Value FROM @table1 LEFT JOIN @table2 ON ([@table1].Id=[@table2].Id) LEFT JOIN @table3 ON ([@table2].Id=[@table3].Id)