-
Write a query: I have 1 parent(account) and 1 child(contact),how will you get F.name,L.name from child and email from the account when Organization name in acc
Write a query: I have 1 parent(account) and 1 child(contact),how will you get F.name,L.name from child and email from the account when Organization name in account is "CTS"?
-
1 Reply
-
Hi Manpreet,
You can use this query
select name, (select firstname,lastname from contacts) from Account where name='CTS'
You can change the fields to the Required Fields according to your need
Log In to reply.
Popular Salesforce Blogs
Benefits of Salesforce Integration for Educational Institutions
Educational institutions are aggressively embracing run-of-the-mill Customer Relationship Management (CRM) systems amidst data and technology-dominated times to - execute a productive workflow, maximize communication, and…
Should You Do Salesforce Backup — All You Need To Know
If you ever lost your data, you know how devastating it is. But what if this data affects the entire enterprise's functioning? Dealing with sensitive…
6 Salesforce Predictions to Transform Your 2023 Business Outlook
Businesses have been leveraging the benefits of CRM platforms for decades now. And when we talk about CRM, Salesforce tops the chart! It comes with…
Popular Salesforce Videos
Salesforce Admin training : How to create a custom app in Salesforce?
In this tutorial, you will learn to create a custom app in Salesforce and go through a quick overview of Profiles. Profiles control the visibility of your…
Salesforce Communities: 5 Powerful Ways to Drive Growth
Salesforce Communities are brand spaces designed specifically for Salesforce customers to connect with the community outside their org (i.e., employees, partners, and customers) and collaborate…
Navy Veteran Turned Solution Engineer Working at Salesforce
In this video, you know how a navy veteran turned Solution Engineer working at Salesforce. This is really inspiring for everyone. The video covered the…
