Addresses with Towns

SELECT TOP(50) e.[FirstName], e.[LastName], t.[Name] AS [Town], a.[AddressText]
FROM [Employees] e
JOIN [Addresses] a ON e.[AddressID] = a.AddressID
JOIN [Towns] t ON a.[TownID] = t.[TownID]
ORDER BY e.[FirstName], e.[LastName]