-
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
All You Need to Know About Salesforce Integrations
Integration In Salesforce, integration refers to the process of connecting and combining different systems or applications to enable the exchange of data and functionality. It…
Email Services in Salesforce - Learn All About It
Salesforce Email Service is an automated process that processes inbound email using Apex classes. We need to create a separate email address for Salesforce to…
Whopping 50 Percent Year-over-year Gain in Global Online Sales – Salesforce Data
As per data revealed by CRM specialist Salesforce, consumers spent $1.1 trillion online worldwide and $236 billion in the U.S. as compared to 723 billion…
Popular Salesforce Videos
SALESFORCE LIGHTS: The Crown above San Francisco
Visible by more than 20 miles away, Jim Campbell's massive LED art installation on the crown of the Salesforce Tower premiered last week. Situated above…
How a Veteran can Start Their Career in Salesforce?
Let's Understand how a veteran can start their career in Salesforce? Please watch the full video and like, share and comment. Shrey is a Chief…
How to Use Dispatcher Console in Salesforce Field Service? | Elevate Field Service Delivery | AblyPro
Dispatcher Console makes field service delivery easy for your business. Using the Dispatcher Console included in the Field Service package, your dispatchers can easily schedule,…
