I have 3 objects.
Event, Invite & Attendee
Event - > Invite (one Event to Many Invites) Master Detail relationship Invite has event details
Attendee - > Invite (one Attendee to Many Invites) Master Detail relationship Invite has Attendee details
Now I want to fetch Attendee from Invites which belong to a particular meeting i.e, fetch Attendee details from Meeting details.
Parent --> Child --> Parent
Is this possible. Please Help.
I used the following Query. It is fetching me all the Attendees irrespective of the meeting.
List<Attendee__c> attns = [select id,name,Attendee_Email__c,Country__c ,(select id,name,Request_Status__c from Invites__r where Meeting__r.name=:meetName) from Attendee__c];
Please help .