-
SOQL to fetch account details through a AccountContactRelation object in Salesforce
Hi,
I am stuck with a problem here.
I have enabled multiple Accounts to Contact in my salesforce org. This creates a junction object called AccountContactRelation.
I need to write a query which would fetch the account details like Account id, name, record type of the Accounts linked to a Contact.
Condition is, only those account details should be fetched where the contact has more than one account linked to it.
Can someone please help. It is urgent
Thanks!
-
1 Reply
-
Hi Martina,
You can use SOQL Query something Like this :
[Select AccountId from Account group by ContactId having count(Name) > 1];
Thanks.
Log In to reply.
Popular Salesforce Blogs
Are You Here To Know Reasons To Hire Salesforce Developer For Your Business?
Are you here because you want to discover why you should hire a Salesforce developer is crucial for your business? In today's rapidly evolving technological…
Salesforce Features To Help Your Nonprofit Organization Succeed
The impacts of non-profit organizations are undeniable, especially when it comes to the people and communities they serve. They have likely changed and touched the…
Lookup Relationship in Salesforce - Here's All You Need to Know
Introduction Lookup Relationship is an object type relationship in Salesforce. It is one to one or one to many relationships between two objects. Some Features…
Popular Salesforce Videos
Salesforce Data Loader | Import Relational Data
What is Data Loader and How to use it to import or export data to or from Salesforce? 00:00 What is Data Loader 01:00 How…
What is Audit Trail in Salesforce? Explain in Detail
Audit Trail helps to track the recent setup changes and is especially useful in organizations with multiple administrators. Learn all about it here.
Pardot vs Marketing Cloud: What's The Difference?
There are different functions of each Salesforce product according to the use cases. Many businesses get confused between Salesforce Pardot and Marketing cloud. Pardot is…
