Hey Steve

Thanks for the reply. Can you please give an example by building a query cause i dont know how to do a join cause there is only 1 table....and...

Hello

Thanks for the reply. In the SQL statement given below,

select sum1,sum2,sum3

from (select........... as sum1

...................

..........................

) Ledger

Was wondering if the Query had any variables declared apart from just this query...cause in...

Hello,

Thanks for your reply. Can you please give me the exact syntax for the above solution that you have proposed? especially,the from syntax for Sum1, Sum2, Sum3 ...

Thanks