I want to look at all members who attended an event on, say, 2012-08-24, and determine if any of them were friends of member 1515.
If no attendees were friends, then the query should return 0 rows.
If at least one attendee is a friend of 1515, then the query should return more than 0 rows.
For this query, I don't actually need the data... I just need a yes/no answer on whether friends of 1515 attended, so I figured I'd get that from the number of rows returned. In the case above, there would be 1 row.
I'm not even coming close to figuring out how to construct that query so any help will be greatly appreciated.
Oh Lord, please help me be the person my dog thinks I am.