I'm having trouble with a nested SOQL query that hits Asset, Contact, and AccountContactRelation. There are two account record types related to contacts and I want to see both, but only one account record type is related to the Asset. Below is my attempt:
SELECT Asset.Name, Asset.Cohort__c, Asset.Account.Name, Contact.Title, Contact.Name, (select AccountContactRelation.Account.Name From AccountContactRelation where AccountContactRelation.Account.RecordTypeId = '123456789abc') FROM Asset
I should add that I am working in Toad Data Point, but have not had any luck with either the developer console editor or the Workbench.
I am relatively new with SOQL and would appreciate any and all help!