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?