Thank you - I also wonder how the sub-query or join would compare to Cross (or Outer) Apply - as in the following query?

SELECT EmployeeID, Salary, RActive, CAM.ManagerName FROM Employees

CROSS APPLY (SELECT ManagerName FROM Managers WHERE Managers.ManagerID = Employees.ManagerID) CAM

WHERE Employees.ManagerID = 1