List out personnel with system roles
| Code Block |
|---|
select system_role.id as system_role_id, person.id as person_id, name, username, role_id, role, system_role.office_id, campus.description
from person, system_role, role, campus, office
where person.id=system_role.person_id and
role.id=system_role.role_id and
office.id=system_role.office_id and
campus.id=office.campus_id order by person_id; |
...