How to Use Join

Question

I have table like

id       |  name     | manager
1        |  A        |    0 
2        |  B        |    1
3        |  C        |    2
4        |  D        |    1

and i want each employee name along with manager name and id.

score 1 · Accepted Answer · answered Oct 18 '15 at 06:23

1

SELECT e.*,
        e1.name
FROM employee e
LEFT JOIN employee e1
ON e.manager = e1.id

answered Oct 18 '15 at 06:23

Alex

Thanks it's working but could you explain it,actully i new so it's hard to understnad. – user3056158 Oct 18 '15 at 13:13

score 1 · Answer 2 · answered Oct 18 '15 at 06:32

1

Say your Table Name is employee and manager

SELECT 
e.id, 
e.name AS empname, 
m.name AS managername
FROM employee AS e 
INNER JOIN manager AS m ON e.manager = m.id

Hope it will help you

answered Oct 18 '15 at 06:32

Shaymol Bapary

2 Answers2