-
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
Choosing Debug Mode and Component Caching to build Lightning Components rapidly and efficiently
As you start developing Lightning Components you must take care of a few settings in Salesforce Org, depending on whether you are in production or…
Amazon CTI Adapter and Service Cloud Voice: What’s Your Choice?
Service Cloud Voice (SCV) was released in 2020 to replace and extend the functionality of the Amazon Connect CTI Adapter, which is used to link…
Unveiling the Top Trio: A Comprehensive Comparison of Three Most Effective Ways to Integrate Multiple Salesforce Instances
Salesforce has long been a dominant force in the CRM landscape, setting the gold standard despite its high costs and challenging implementation process. Its ability…
Popular Salesforce Videos
What is the Future of Salesforce Developer?
Salesforce Developer jobs are on the rise. A lot of MNC companies like TCS, Infosys, Cognizant, etc are hiring Salesforce developers. In this video, Musings…
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…
Objects and Tabs in Salesforce
Watch this video to learn all about Objects and Tabs in Salesforce. If you have any doubts or concerns please let us know in the…
