-
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
Accelerating Vaccine Management With Salesforce's Vaccine Cloud
Local and international government officials and healthcare workers are currently delivering the most extensive mass vaccination campaign in human history. The formulation and creation of…
What are Field Dependencies in Salesforce in 2023? | All You Need to Know
Salesforce is a powerful CRM platform that allows businesses to customize and tailor the software to their specific needs. One of the ways this is…
Integrating Salesforce CDP Marketing Cloud with Salesforce CRM: A Comprehensive Guide
A business can affect customers in numerous ways. One of them is giving proper experience on the digital platform. Salesforce is a powerful tool that…
Popular Salesforce Videos
Salesforce Chatter Training - Staff
In this video, Kylee Durant provides a Salesforce Chatter Training overview, detailing how to enable and configure chatter groups, as well as create customer groups.
Salesforce Lightning Tutorial - How to Delete Records from Server
In this particular video you'll learn how to delete records from custom Salesforce Lightning Component using Apex Controller Method.
Login Flow In Salesforce
You can use a login flow to customize the login experience and integrate business processes with Salesforce authentication. Common use cases include collecting and updating…
