Say I have an event ID, and the goal is to get the event data and the names of every contact associated with the event in the
Currently I look up the event record with the event ID from the
Event object and run a separate query on the
EventRelation object (also with event ID), and for each matching row in
EventRelation, lookup the relation ID in the
Contact object to get the contact names.
Basically this is a lot of calls, is it possible to do this all in one query?