In this query select last_name, first_name, job_title, site_name from staff_site_link_expanded_view order by last_name, first_name
It lists some of the staff more than once as they have multuple offices (site_name).
I would like a list of which staff has this, more than one site_name.
I would like just their last_name, and first_name who has multi site_name
For example this staff:
|ANDREWS|GARY|Clinician |Wood Admin Office|
|ANDREWS|GARY|Clinician |Genola Admin Office-East|
|ANDREWS|GARY|Clinician |Genola Admin Office-West|
|ANDREWS|GARY|Clinician |Bevins Street Admin Office|