Database query a complex select statment

Question

I have table which have id name and manager id

id  name  manager_id
1  myName  4
2  alex    3
3  brain   2
4  someone 1

Now i have to write the query which display the result like that

myname someone
alex brain
brain alex
someone myname

Means we have to display name and mnager Name according to the Id

nobody · Accepted Answer · 2011-08-01 10:30:09Z

5

join the table with itself:

SELECT t1.name, t2.name FROM my_table AS t1 
    LEFT JOIN my_table AS t2 ON( t1.manager_id = t2.id )

answered Aug 1, 2011 at 10:30

nobody

10.7k4 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ain · Accepted Answer · 2011-08-01 10:29:36Z

4

Does this return what youre after?

SELECT
  t1.name AS Name,
  t2.name AS manager
FROM tab t1
  JOIN tab t2 ON(t1.manager_id = t2.id)

answered Aug 1, 2011 at 10:29

ain

22.8k3 gold badges60 silver badges76 bronze badges

Dan Grossman · Accepted Answer · 2011-08-01 10:30:19Z

2

SELECT
  employee.name,
  manager.name
FROM
  tablename employee
INNER JOIN
  tablename manager
ON
  employee.manager_id = manager.id

Replace tablename with the actual table name.

answered Aug 1, 2011 at 10:30

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges