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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Adding amount from two query outputs

Author  Topic 

asad.lte
Starting Member

32 Posts

Posted - 2010-04-29 : 09:08:03
hi guys,

thnx in advance for da help u people doing to the people in need

two queries giving amounts i just want to add that fee as single amount as total fee amount,help is needed

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-29 : 09:18:56

select sum(amount) as amount from
(
query1
union all
query2
) as t

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -