-
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
End-to-End Salesforce Services in the USA: Transforming Business with DigiIQ
In the rapidly evolving digital economy of the United States, businesses are under constant pressure to innovate, scale efficiently, and deliver seamless customer experiences. Organizations…
From Lead Generation to Closing: Solving Sales Cycle Inefficiencies with Salesforce
The sales cycle is crucial to the success of any business, as it directly impacts revenue and customer acquisition. In fact, according to Salesforce’s State…
Introducing the New Salesforce Nonprofit Cloud
In collaboration with community users and partners, Salesforce is introducing a new Nonprofit Cloud! Currently, nonprofit organizations install a variety of nonprofit-related applications on top…
Popular Salesforce Videos
How To Set Up Gmail With Salesforce | Salesforce Development Tutorial
Learn how to set up Gmail with Salesforce. The following points will be covered in this tutorial - 1. Lightning for Gmail Get a brief…
Driving Gamified Interactions on Salesforce Communities With ScoreNotch | Use-Cases
A Salesforce native and lightning-ready product that makes gamification more dynamic and engaging. It encompasses powerful features that boost community engagement and ROI. Do let…
How to Configure SAML Single Sign-On with Salesforce as the Identity Provider
Configure single sign-on with a Salesforce org as the identity provider for an external Heroku app acting as the service provider, using SAML. Watch this…
