Sample Contact Record:
SOQL:
SELECT Id, AccountId, Account.Name FROM AccountContactRelation WHERE ContactId IN (
SELECT Id FROM Contact WHERE Email = ‘[email protected]’ )
SELECT Id FROM Contact WHERE Email = ‘[email protected]’ )
Output:
How to Query/Fetch all accounts which are associated with a particular email id in Contacts to Multiple Accounts Relationship?