Untitled

--query Kitti
SELECT e."name"  as "Empresa",u.identifier , concat(u."name", ' ' ,u.lastname) as "Nombre" , u.email , a.username , 
case when a."locked" = true then 'Cuenta Bloqueada'   
      else  'Cuenta activa' end as "Estado cuenta"
FROM user_enterprises ue 
JOIN users u ON (u.id = ue.user_id)
join accounts a on (a."token" = u."token")
join enterprises e on (e.id = ue.enterprise_id)
where ue.enterprise_id = 91 --id empresa
and u.lastname <> e."name" ;