SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.FIRST_NAME, EMPLOYEES.LAST_NAME,
  EMPLOYEES.HIRE_DATE, EMPLOYEES.SALARY, DEPARTMENTS.DEPARTMENT_NAME,
  LOCATIONS.CITY 
  FROM EMPLOYEES, DEPARTMENTS, LOCATIONS 
  WHERE EMPLOYEES.DEPARTMENT_ID=DEPARTMENTS.DEPARTMENT_ID 
  AND DEPARTMENTS.LOCATION_ID=LOCATIONS.LOCATION_ID 
  ORDER BY CITY
 
