Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select temp.institucion ,sum(temp.saldo_ahorro) as saldo from(
- SELECT
- c.id_cuenta_ahorro
- ,c.saldo_ahorro
- ,c.nombre_centro_costos
- ,camp.no_cuenta_medio_pago as clabe
- ,e.nombre
- ,c.distribuidor
- ,c.grupo_trabajo
- ,case camp.id_medio_pago
- when 3 then 'STP'
- when 4 then 'ASP Integra'
- end as institucion
- FROM
- cuenta_ahorro_cliente c
- join producto_ahorro_empresa pae on c.id_producto_ahorro_empresa = pae.id_producto_ahorro_empresa
- join empresa e on e.id_empresa = pae.id_empresa
- join cuenta_ahorro_medio_pago camp on camp.id_cuenta_ahorro = c.id_cuenta_ahorro
- WHERE
- e.id_empresa NOT IN (11,377,464,208)
- and c.id_cuenta_ahorro NOT IN (2101,3128,1561,3122,1610)
- and camp.id_medio_pago in (3,4)
- and c.saldo_ahorro > 0.01
- GROUP BY
- c.id_cuenta_ahorro
- ) as temp group by temp.institucion
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement