INNER JOIN第三张表

here is code

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

how can i add third table and row to this

profile_portal pp_main_photo

Add a second join to jour statement.

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>

 INNER JOIN profile_portal ON <YOUR CONDITIONS>

AND ABOUT ERROR : $res does not have the data fro resultset. So please check query whether it return the value.