sum the values more querys

Hi ,

instead of union use temporary table.

insert into #temp 

select max(iscore) score from hospitals where flatid='F001'

insert into #temp

select max(iscore) score from Restaurants where flatid='F001'

insert into #temp

select max(iscore) score from Transports where flatid='F001'

insert into #temp

select max(iscore) score from Markets where flatid='F001'

select SUM(score) from #temp

drop table #temp

Thanks,
Sanjay

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

You can also get by using following query,

select sum(iscore) from (
select max(iscore) from hospitals where flatid='F001'
union all
select max(iscore) from Restaurants where flatid='F001'
union all
select max(iscore) from Transports where flatid='F001'
union all
select max(iscore) from Markets where flatid='F001') temp

Thanks,
Rajni Shekhar

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator