-
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
5 Expert Tips To Make Testing In Salesforce Easier
Testing in Salesforce is not easy. Since many of the classes are standard Salesforce classes that you don’t have any control over, and can’t customize,…
Knowledge of Sandboxes | Types of Sandbox in Salesforce
What is the Sandbox in Salesforce? A Sandbox is an isolated testing environment wherein the users can execute or run programs and files without affecting…
Creating and Converting Leads in Salesforce | The Ultimate Guide
Leads are potential customers who have shown interest in a company’s product or service. Converting leads into paying customers is a critical step in the…
Popular Salesforce Videos
How Cyntexa Helped Diet Meal And Food Ordering Service Providers Offer Their Users The Ability To Order Online | Salesforce Commerce Cloud
It is important to keep your business at the top with the latest technical advancements. Presenting you a case study showcasing how Cyntexa Helped Diet…
How to import data from Sage ERP to Salesforce - Part 1
Greytrix offers GUMU™ integration for Salesforce with Sage ERP systems - a best-of-breed solution for organizations to enhance their customer interaction. With Salesforce and Sage…
Sales Process in Salesforce | Opportunity Object Explained
Opportunities in Salesforce Sales Cloud allow sales teams to organize and track their sales pipeline effectively. Each opportunity represents a potential deal, and it can…
