InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 13:08:03 GMT20http://www.sqlservercentral.com/Forums/Topic620820-145-1.aspxIt worked .Thanks Gil.Tue, 16 Dec 2008 16:23:20 GMTSarwanhttp://www.sqlservercentral.com/Forums/Topic620820-145-1.aspxThe columns in the table a ,b ,c are already using aggregate functions like max(duration) ,min(perf),avg(proc)Tue, 16 Dec 2008 16:14:30 GMTSarwanhttp://www.sqlservercentral.com/Forums/Topic620820-145-1.aspx[code]SELECT SUM(SomeColumn) FROM ( SELECT SomeColumn FROM TableA UNION ALL SELECT SomeColumn FROM TableB UNION ALL SELECT SomeColumn FROM TableC) sub[/code]Tue, 16 Dec 2008 16:03:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic620820-145-1.aspxHi,table A which has 4 recordsunion allTable B -has 4 records --getting result set using 3 tablesunion all table c - has 4 records..when i use union all I'm getting 12 records altogether in a result set..My question is i want to see the sum of all records so that i will get only 1 record in the result set.Tue, 16 Dec 2008 16:00:55 GMTSarwan