Untitled

SELECT e.employee_id, e.first_name, e.last_name FROM employees e JOIN departments d ON e.department_id = d.department_id JOIN locations I ON d.location_id L.location_id WHERE I.location_id = 1700;