View: office.user_selector_view

 CREATE OR REPLACE VIEW office.user_selector_view
 AS
 SELECT users.user_id,
    users.user_name,
    users.full_name,
    roles.role_name,
    offices.office_name
   FROM office.users
   JOIN office.roles ON users.role_id = roles.role_id
   JOIN office.offices ON users.office_id = offices.office_id;