-
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
Data Management in Salesforce - Here is All You Need to Know
This is the important part to understand clearly as an administrator. In this blog we are going to learn about how the data is imported…
How Salesforce Can Benefit Real Estate Business?
As a real estate agent, your primary goal is to close deals quickly while providing outstanding customer service. However, with a never-ending stream of leads…
5 Compelling Reasons to Invest In Salesforce Integration Services
As a Customer Relationship Management tool, Salesforce is one of the world’s best and most popular platforms. But don’t take our word for it! Marc…
Popular Salesforce Videos
Salesforce Health Cloud
Salesforce Health Cloud is a health IT CRM system that incorporates doctor-patient relationship and record management services. Through Private Communities, patients can view care plans,…
How to Elevate Engagement with Salesforce Experience Cloud?
Salesforce Experience Cloud helps companies create personalized portals for customers to find answers, collaborate, and be part of a community. In this video, ENWAY will…
When to use which Sandbox? Salesforce Interview Questions and Answers
Watch this video by CRS Info Solutions to when to use which Sandbox. Salesforce sandboxes are copies of your Production environment. A Sandbox contains all the…
