select * from employees e join departments d on e.department_id = d.department_id where d.location_id=2;
