Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

List out personnel with system roles

select person.id as person_id, name, username, role_id, role, office_id from person, system_role, role
where person.id=system_role.person_id and
role.id=system_role.role_id;


  • No labels