mysql - 获取所有用户 friend 有意想不到的结果

Question

让我们说:

table users(id, name, ..)
table friends(uid, fid)

如何获得33456用户id的好友？

 SELECT fid idd, name
    FROM users, 
         friends 
WHERE uid = 33456
    AND fid = id

但会给我意想不到的结果

Answer 1

SELECT  id, fid, name
FROM users,friends where users.id=friends.fid
WHERE users.id = 33456