AnsweredAssumed Answered

Finding like related records.

Question asked by KylePutzier on Mar 16, 2012
Latest reply on Mar 16, 2012 by KylePutzier

I have a table of people. The people in that table have many related friends in a different table. How can I tell if a particular person has the same friend as another person? Each persons friend(s) would be a different record in the friends table.

It sounds like I'm making up the people and friends scenario, but believe it or not, that is the actual scenario. I need to figure out (and show) who has common friends. I'm going to assume that the friends table has a somewhat reliable identifier like a phone number or something. I don't have that actual data yet.

 

BTW, I could decide on a good name for this topic. What do you think it should have been?

 

Kyle

Outcomes