Consulta SQL

[Andres95]

Código:

Select  R.Anio           as ['Anio']
       ,R.Mes            as ['Mes']
       ,R.CodUsu         as ['CodUsu'] 
       ,Sum(R.Deposito)  as ['SumaDeposito']
From 
   (Select  Year(Fecha)       as ['Anio']
           ,Month(Fecha)      as ['Mes']
           ,C.CodUsu1         as ['CodUsu'] 
           ,Sum(D.Deposito)   as ['SumaDeposito']
   From     Cliente  C 
   Inner join 
            Diario  D
   On       C.CodUsu1 = D.CodUsu 
   Group by Year(Fecha) 
           ,Month(Fecha)
           ,C.CodUsu1
   
   Union all
   
   Select   Year(Fecha)        as ['Anio']
           ,Month(Fecha)       as ['Mes']
           ,C.CodUsu2          as ['CodUsu'] 
           ,Sum(D.Deposito)    as ['SumaDeposito']
   From     Cliente  C 
   Inner join 
            Diario  D
   On       C.CodUsu2 = D.CodUsu 
   Group by Year(Fecha)
           ,Month(Fecha)
           ,C.CodUsu2
   ) as R
Group by  R.Anio
         ,R.Mes
         ,R.CodUsu
Order by  R.Anio DESC
         ,R.Mes     DESC
         ,R.CodUsu

Saludos!