how to show two query results as one

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to show two query results as one

Author

Topic

dhani
Posting Yak Master

132 Posts

Posted - 2008-09-18 : 09:40:02

hello all

can any one please tell me how to do below way

i have 2 tables (ex table1, table2)

Query1:
select sum(col1) from table1

Query2:
select sum(col2) from table2

how can i show addition of above two queries (i.e., query1 result + query2 result)

thanks in advance
Dhani

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-18 : 09:50:23

select sum(summation) as summation from
(
select sum(col1) as summation from table1
union all
select sum(col2) from table2
) as t

Madhivanan

Failing to plan is Planning to fail