Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- cac.id_cuenta_ahorro as idCuenta,
- cac.id_cliente as idCliente,
- cac.id_producto_ahorro_empresa as idPAE,
- pae.nombre_producto,
- pa.id_producto_ahorro as idProducto,
- pa.nombre as tipoProducto,
- case cac.tipo_persona
- when 0 then 'FĂsica'
- when 1 then 'Moral'
- end as persona, -- 0: fisica, 1:moral
- cac.saldo_ahorro,
- date(cac.fecha_alta) as fechaAlta,
- case cac.activo
- when 0 then 'Activa'
- when 1 then 'Inactiva'
- when 2 then 'Autorizar retiro parcial'
- when 3 then 'Autorizar retiro total'
- when 10 then 'Eliminada'
- end as estatus,
- cac.alias,
- cac.distribuidor,
- cac.grupo_trabajo,
- cac.no_cuenta as cuentaEje,
- cac.id_cuenta_ahorro_padre as cuentaMadre
- from
- alquimia_vitae.cuenta_ahorro_cliente cac
- join producto_ahorro_empresa pae
- on pae.id_producto_ahorro_empresa = cac.id_producto_ahorro_empresa
- join producto_ahorro pa on pae.id_producto_ahorro = pa.id_producto_ahorro
- where id_cuenta_ahorro = ?;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement