SELECT        CONCAT(Employees.FirstName,' ',Employees.MiddleName, ' ', Employees.LastName) AS Name,
              Orders.ShipCity
FROM          Employees INNER JOIN
              Orders ON Employees.EmployeeID = Orders.EmployeeID