List is in another list

Hey all I have something I cant quite figure out to do with a search…

I have a person with a list of friends
I also have an event of which people are going to

What I want to do is formulate a search that returns results where the person has 1 or more friends that are going to the event.

something like search for events where persons friends are in events going to list…

If i get exact database structure then, will provide exact solution,
I have done, as per your comments,
Hope this will help

This topic was automatically closed after 70 days. New replies are no longer allowed.