TSQL puzzle

[Neo L.]

Hi,
I have two tables as follows:

table employees:
EMP_ID EMP_NAME MANAGER_ID
0 NONE 0
1 JOHN 3
2 MARY 4
3 TOM 4
4 HELEN 0

table profiles:
EMP_ID PNAME
1 Programmer
2 Analyst

I need to report the Programmer's and Analyst's manager name.
So the result should be:
PNAME Manager
Programmer TOM
Analyst HELEN


Thank you so much!

[Erland Sommarskog]

Post by Neo L.
EMP_ID EMP_NAME MANAGER_ID
0 NONE 0
1 JOHN 3
2 MARY 4
3 TOM 4
4 HELEN 0
EMP_ID PNAME
1 Programmer
2 Analyst
I need to report the Programmer's and Analyst's manager name.
PNAME Manager
Programmer TOM
Analyst HELEN

SELECT p.PNAME, m.EMP_NAME AS Manager
FROM profiles p
JOIN employees e ON p.EMP_ID = e.EMP_ID
JOIN employees m ON m.EMP_ID = m.MANAGER_ID