how to get total of a column which is sum from other tow colunms

[kate8]

Hi All,

I need a total amounts from a column which is also sum of other columns. How can I do it?

select sum(coalesce(payment1,payment2)) payment
from mytable1 t1
left join mytabel2 t2 on ti.id1=t2.id1
where ...
group by ..

Now I need total of payment, how can I do it?
Thank you so much for any helps!!!

 

[imex]

Hi,

I believe you can use Grouping Sets:

http://www.codeproject.com/Articles/29312/Grouping-Sets-in-T-SQL-SQL-Server-2008

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[kate8]

Hi imex,

Thank you for the information!!
I created a table variable and insert all select into it, then select from the table variable and sum the field.