SELECT (e.FirstName + ' ' + e.LastName) AS Employee,
    isnull((SELECT m.FirstName + ' ' + m.LastName FROM Employees m WHERE e.ManagerID = m.EmployeeID), '(no manager)') AS Manager
FROM Employees e