I need help with a Query to get a managers name and all of their direct reports

[clschone]

What I am trying to do is create a report that takes the userid of the person runing the report and pulls in all of the userid/username that reports to the person running the report.

[CollinCampbell]

SELECT [USERID]
FROM [USERSECURITY] WHERE MANAGERID = {ManagerId}

[clschone]

Thanks

But what I am struggling with is getting the actual names for a report.

---

@CollinCampbell wrote:

SELECT [USERID]
FROM [USERSECURITY] WHERE MANAGERID = {ManagerId}

---

[CollinCampbell]

SELECT US.[USERID]
,US.[USERCODE]
,UI.USERNAME
FROM [USERSECURITY] US JOIN [USERINFO] UI ON US.USERID = UI.USERID
WHERE MANAGERID = {ManagerId}