php mysql join same table

Question

Is it possible to join from the same table?

my database

╔════╦══════╦════════╗
║ id ║ name ║ Leader ║
╠════╬══════╬════════╣
║  1 ║ Eric ║   2    ║
║  2 ║ Ivan ║   0    ║
╚════╩══════╩════════╝

What I want to show is (id = 1 , name = Eric , Leader = Ivan)

This is my query:

$result= mysql_query("SELECT member.*, leader.* from table AS member
                      INNER JOIN table AS leader ON member.id = leader.id
                      WHERE member.id = ... 
                     ");

SELECT member.id, member.name, leader.name AS leader FROM table as member JOIN table as leader ON member.leader = leader.id WHERE member.id = 1 — Lukasz Szozda
– Lukasz Szozda, Commented Jan 28, 2016 at 7:14

Tim Biegeleisen · Accepted Answer · 2016-01-28 07:13:43Z

3

Here is a self join query which will achieve what you want:

SELECT member.name AS name, leader.name AS leader
FROM table AS member
INNER JOIN table AS leader
    ON member.Leader = leader.id
WHERE member.id = 1

answered Jan 28, 2016 at 7:13

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

php mysql join same table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related