Fetch account details using "AccountContactRelation" junction object in Salesforce

Hi Martina,

It will be a two-step process. First, you need to fetch all contact ids which has more than one contact.In the second step, you can retrieve Account information.

set<Id> setOfContactIds = new set<id>();
for(Contact conObj : [select id, (select id from AccountContactRelations where isDirect = false) from contact]){
if(conObj.AccountContactRelations.size()>0){
setOfContactIds.add(conObj.id);
}
}
system.debug('::'+[select id, Account.name from AccountContactRelation where ContactId IN:setOfContactIds]);