是否可以从同一张桌子加入?
我的数据库
╔════╦══════╦════════╗
║ id ║ name ║ Leader ║
╠════╬══════╬════════╣
║ 1 ║ Eric ║ 2 ║
║ 2 ║ Ivan ║ 0 ║
╚════╩══════╩════════╝
我想展示的是(id
= 1 , name
= Eric , Leader
= Ivan)
这是我的查询:
$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.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