-
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
Salesforce vs Hubspot: Which CRM is the Best Fit for Your Business Needs?
As companies grow and expand, managing customer relationships becomes a complex and challenging task. This is where customer relationship management (CRM) software comes into play.…
Insert sObject record using Javascript in Salesforce Visualforce Page
How to insert record in Salesforce by using Javascript In this blog, I will let you know how to insert record in Salesforce by using…
New AI-Powered Salesforce Education Cloud to Boost Student Success
A few days ago, Salesforce unveiled its new AI-powered Salesforce Education Cloud. This includes Intelligent Degree Planning and Skills Generator, designed to help institutions provide…
Popular Salesforce Videos
Salesforce Nonprofit Cloud Explained
Discover how Salesforce Nonprofit Cloud helps organizations drive social change through better donor management, volunteer coordination, and streamlined operations. In this video, we'll explore the…
Connecting to Salesforce in Outlook
Bring together the two platforms you use everyday: Salesforce and Microsoft Outlook. View and work with Salesforce data directly in your Outlook inbox, create Salesforce…
Pass Salesforce Certification Exam In Your First Attempt
This Salesforce Training Video will help you understand the concepts of Salesforce and Salesforce exam so that you can pass the Salesforce exam in the…
