CODEWITHSUNDEEP
phpmysqljoin
kc low
kc low

Reputation: 3

php mysql join same table

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 = ... 
                     ");

Upvotes: 0

Views: 1298

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 520958

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

Upvotes: 3

Related Questions