-
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
What is Einstein GPT? World's First Generative AI for CRM
Introduction Meet Salesforce's Einstein GPT, a new addition to the ever-expanding array of chatbots with AI capabilities. The service stands out slightly from the competition…
10 Distinctive Salesforce Features To Make Your Tasks Easy
Salesforce, the global CRM leader has a lot of features and functionalities to offer but there are some unique and cool features and to look…
Leveraging Salesforce and Tableau Integration for Better Visualization
A lot of businesses around the world leverage Salesforce as their CRM tool for engaging with and understanding their customers. While Salesforce equips users with…
Popular Salesforce Videos
Kizzy Consulting - Top Salesforce Partner Intro Video
Kizzy Consulting is a Salesforce Consulting Partner and has successfully implemented 100+ Salesforce projects for 100+ clients across sectors like Financial Services, Insurance, Retail, Sales, Manufacturing,…
Salesforce on Salesforce: How Salesforce Uses Trailhead to Drive Enablement
With Trailhead, Salesforce is transforming the learning experience for our employees at every step of their career journey. Join us to learn tips, tricks and…
Salesforce Administrator and App Builder Training
S2 Labs Salesforce admin certification training Tutorials for FREE. In this course, you will learn about the Salesforce Platform Basics, customizing Salesforce with Lightning Experience…
