I'm wondering if it is possible to query the Opportunities object and return associated Account and Contact data.
I so far have:
SELECT Opportunity.Id, Opportunity.AccountId, Opportunity.Owner.Name, Account.Company_Division__c, Account.Name, Account.BillingStreet, Account.BillingCity, Account.BillingState, Account.BillingPostalCode, Account.Phone, Account.Fax FROM Opportunity
But I can't figure out the syntax to get the Contacts that are associated with the Account.
I know it has something to do with the AccountContactRelations object, but I can't seem to get there from the Opportunity object.
** This question is NOT looking for the OpportunityContactRole, but rather contacts associated with an Account. **
P.S.: The code I'm working with will take hours to fix if I have to change the
FROM Opportunity part of this query. I would greatly prefer to not change that if possible. Thanks!