-
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
Maximizing Your Salesforce Platform ROI: 10 Proven Strategies
Introduction Salesforce is a seamless platform that can help businesses of all sizes streamline their sales, customer service, and marketing processes. However, simply investing in…
Why Enterprises Should Implement Salesforce Development and Consulting Services?
Investing completely during a Salesforce Customer Relationship Management tool doesn’t guarantee you success in business or necessarily improve your customer relationship strategy. You still have…
Guided Selling in Salesforce for Sales Reps in 2024
Guided selling is a game-changing approach that streamlines the sales process by swiftly identifying customer needs and aligning them with company objectives. Data backs the…
Popular Salesforce Videos
How to Get A Part Time Salesforce Job
In this video, Brad discusses different techniques to convince a potential employer to offer you a part-time Salesforce position. This job option allows for additional…
What is CRM and How Does it Work? | Salesforce
What is CRM (Customer Relationship Management) and how does CRM work? Watch this video to see how CRM helps you keep track of everything about…
How To Use Journey Builder In Salesforce Marketing Cloud | Salesforce Tutorial
How to use Journey Builder in Marketing Cloud. This video will cover the following points - 1. Introduction Get a brief introduction to Journey Builder…
