SELECT employees.firstName,offices.city 
FROM `employees` JOIN offices ON employees.officeCode=offices.officeCode