Versions Compared

Version Old Version 1 New Version 2
Changes made by

Cameron Ahana

Cameron Ahana

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

List out personnel with system roles

Code Block
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;