SELECT *
FROM MyDatabase.MySchema.MyTable;

SELECT *
FROM OneDatabase.dbo.EmployeeLocation el
JOIN SomeDatabase.dbo.Location l ON el.locationcode = l.locationcode
JOIN AnotherDatabase.dbo.Employee e ON el.employeeID = e.employeeID
                              AND l.locationID = e.locationID