SELECT dt1.Descarga, SUM(Balance) FROM ( Select A.Cuenta,A.Descripcion, Isnull((Select Balance From CNTBal03 Where Cuenta=A.Cuenta And Periodo=12 and Fiscal='2003' ),0) +Isnull((Select Sum(Debito-Credito) From CNTDET02 Where Cuenta=A.Cuenta And Periodo=1 And Fiscal='2004'),0)+ Isnull((Select Sum(Debito-Credito) From CNTDET02 Where Cuenta IN (Select Cuenta From CNTCuentas Where lTrim(rTrim(Descarga)) = lTrim(rTrim(A.Cuenta)) And Periodo=1 And Fiscal='2004')),0) As Balance, A.Descarga From cntCuentas A Order By rTrim(lTrim(A.Cuenta)) ) dt1 GROUP BY dt1.Descarga>Can you give me an example? I'm sorry, new to SQL syntax :)