sql - 帮助了解共同 friend 的fql查询

Question

需要在不使用JS的情况下获得共同 friend 的姓名和照片。

在下面找到了共同 friend 的FQL查询:
"SELECT uid1 FROM friend WHERE uid2=[targetID] AND uid1 IN (SELECT uid2 FROM friend WHERE uid1=[sourceID])"
有没有一种方法可以让我获得此人的姓名和照片，而不是只返回uid1？

编辑
-----------认为我找到了。
"SELECT first_name, last_name, pic_small FROM user WHERE uid IN(SELECT uid1 FROM friend WHERE uid2=['targetID'] AND uid1 IN (SELECT uid2 FROM friend WHERE uid1=['sourceID']))
"

Answer 1

SELECT uid, first_name, last_name, pic_small
FROM user
WHERE uid IN (
    SELECT uid2
    FROM friend
    WHERE uid1 = ['sourceID']
)
AND uid IN (
    SELECT uid2
    FROM friend
    WHERE uid1 = ['targetID']
)

这将找到与源用户(B)和目标用户(C)都为好友的任何用户(A)。不一定相反。 A与B和C成为 friend 。

如果 friend 表确实是镜像的(即，对于每行(x，y)，也有行(y，x))，则此区别将无关紧要。