query to find mutual friends - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

query to find mutual friends

Author

Topic

onlyforme
Starting Member

25 Posts

Posted - 2008-10-16 : 07:06:13

hi friends,
i have From_id and To_id are the member id's of member table which is the table for storing member details

Entry_id,From_id,To_id,Friends_status these are the columns
From_id is the id of person who sends the frd request
To_id is the id to which request is sent
Friends_status becomes 1 if request is accepted else 0

My reqirement is to find the mutual friends.its urgent plz help me.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-16 : 07:12:30

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72097
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89213
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=100816

E 12°55'05.63"
N 56°04'39.26"

onlyforme
Starting Member

25 Posts

Posted - 2008-10-16 : 07:58:35

thanku peso

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources