Advertisement
jcarlosriverae

usuarios por empresa

Sep 29th, 2021
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 KB | None | 0 0
  1.     SELECT
  2.         mf.id_cliente,
  3.         mf.id_empresa,
  4.         e.nombre as empresa,
  5.         mf.id_cuenta_ahorro,
  6.         c.apellido_paterno,
  7.         c.apellido_materno,
  8.         c.nombre
  9.     from moral_fisica_roles mf join empresa e on e.id_empresa=mf.id_empresa join cliente c on c.id_cliente = mf.id_cliente
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement