有没有办法在没有子查询的情况下加入这两个查询? [英] Any way to join these two queries without subquery?

问题描述

我有这个查询:它获取特定用户的朋友列表

SELECT GROUP_CONCAT(friend_id) AS friends
FROM friends_friends 
WHERE user_id = 503695576;

这给了我一个逗号分隔的特定用户朋友列表.

Which gives me a comma delimited list of that particular users friends.

然后使用该查询我有这个查询:它获取用户朋友，朋友的列表

Then using that query I have this query: It gets the list of the users friends, friends

SELECT friend_id
FROM friends_friends 
WHERE user_id IN(friends);

我在连接等方面没有太多经验，但无论如何我可以进行连接或类似的操作来进行这个查询吗?

I am not too experienced in joins, etc, but is there anyway I can do a join or something similar to make this one query?

推荐答案

SELECT GROUP_CONCAT(l2.friend_id) AS friends
FROM friends_friends l1
  JOIN friends_friends l2
    ON l2.user_id = l1.friend_id
WHERE l1.user_id = 503695576;

这篇关于有没有办法在没有子查询的情况下加入这两个查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！