php - INNER JOIN 第三个表

Question

这是代码

SELECT profile_friends.friends_friend_id,
       members.name,
       profile_friends.friends_member_id,
       members.member_id
FROM profile_friends
INNER JOIN members ON profile_friends.friends_friend_id=members.member_id

如何添加第三个表和行

个人资料门户 pp_main_照片

Answer 1

添加第二个 join 到 jour 语句。

SELECT profile_friends.friends_friend_id, members.name, profile_friends.friends_member_id,members.member_id,pp_main_photo
FROM profile_friends
INNER JOIN members
ON profile_friends.friends_friend_id=members.member_id
INNER JOIN profile_portal on <condition>