PostgreSQL 连接 inner join on

PostgreSQL 连接 inner join on

select su.id,su.real_name,sur.role,sra.authority  from sys_user_ex su inner join sys_user_role_ex sur on su.id=sur.user_id
inner join sys_role_authority_ex sra on sra.role=sur.role