-
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
What Is Salesforce Workbench - The Complete Developer Guide
What is Salesforce Workbench? Salesforce Workbench is a tool that brings together a number of advanced features and capabilities into one place. A lot of…
Integrating Salesforce with AI and Machine Learning Tools | The Ultimate Guide
Salesforce is a cloud-based customer relationship management (CRM) platform that helps businesses manage their sales, marketing, and customer service operations. Integrating Salesforce with AI and…
How Salesforce CPQ Software Eliminates Sales Hurdles?
In this era of an automated CRM solution like Salesforce CPQ, if your sales team is still struggling in generating quotes, writing proposals and closing…
Popular Salesforce Videos
Salesforce Service Cloud Voice Demo
Salesforce Service Cloud Voice uses intelligent telephony to increase agent productivity and better serve customers, from anywhere. Today, customers can connect with companies across almost…
Salesforce Anywhere: Technology Enabling the All-Digital, Work-From-Anywhere World
While companies, governments and organizations are slowly returning to their offices, the COVID-19 pandemic has changed the future of work forever. In fact, nearly 70…
Add Intelligence to Any Salesforce App with Einstein Discovery
Bring intelligence in the context on any Force.com app thanks to the power of Einstein Data Discovery. Any Salesforce Admin or Developer can add in…
