MySQL Forums
Forum List  »  Newbie

Re: advice on queries
Posted by: Glenn Nall
Date: September 22, 2016 04:49PM

the moderators want to see my previous posts first, i suppose because I put a link in them...

how does this look for something where i'd want to chain up a string of associations:

there's only the one table that contains user_id and friend_id, so i'm assuming I'd need a table containing persons' names and data and extend this out somehow?


select friend_id
from friends
where user_id = 1
) union (
select distinct ff.friend_id
from
friends f
join friends ff on ff.user_id = f.friend_id
where f.user_id = 1
)

Options: ReplyQuote


Subject
Written By
Posted
September 21, 2016 08:22PM
September 22, 2016 11:03AM
September 22, 2016 04:09PM
September 22, 2016 04:11PM
September 22, 2016 06:37PM
September 22, 2016 06:56PM
September 22, 2016 08:37PM
September 22, 2016 08:49PM
September 23, 2016 08:37AM
September 23, 2016 09:25AM
September 22, 2016 08:53PM
September 22, 2016 04:12PM
Re: advice on queries
September 22, 2016 04:49PM
September 22, 2016 04:53PM
September 23, 2016 04:00AM
September 23, 2016 09:30AM
September 23, 2016 12:40PM
September 23, 2016 12:42PM
September 23, 2016 12:58PM
September 26, 2016 04:05AM
September 23, 2016 12:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.