Requirement:-I need to fetch userName,UserID along with manager names and manager profileName in single query .
i have used below query but i am not getting manager profileName
select userName,UserID,manager.name,manager.Id from user
How should i fetch manager-Profile name here
Does this work for you?