-
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
A Trip to the World of Salesforce Einstein Analytics
Hello Everyone, Welcome to the World of Analytics. Here we begins a trip to the world of Analytics. What's about Analytics? In the glowing era…
Salesforce Sales Cloud - All You Need To Know
Sales Cloud by Salesforce is the perfect platform for organizing and streamlining your sales processes. From creating product logs to creating campaigns and managing contacts,…
Navigating Salesforce Test Automation: A Comprehensive Guide for Engineers
Organizations increasingly rely on advanced tools to keep pace with frequent releases in the rapidly evolving software development world. This blog provides engineers, testers, product…
Popular Salesforce Videos
What Are Roll-Up Summary Fields in Salesforce? | Video Tutorial
A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display…
How Salesforce Industries can Help Organizations to Save Millions?
Salesforce Industries i.e Vlocity empowers businesses with powerful platforms to boost collaboration and makes it easy to deliver great customer experiences. It provides tailored solutions…
Salesforce Marketing Cloud Tutorial | Online Training
Salesforce Marketing Cloud (SFMC) is Salesforce’s platform (or “Cloud”) in the area of marketing automation and customer engagement. It is a SaaS platform made up…
