• Why not the following?

    SELECT a.EmployeeID,a.Salary a.RActive

    b.ManagerName

    FROM Employees a (nolock)

    ,Managers b (nolock)

    WHERE b.ManagerID = 1

    AND a.ManagerID = b.ManagerID;