-
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
Become an Advanced Salesforce Administrator [Exam Notes]
Have you ever doubted your skills of becoming an Advanced Salesforce Administrator? Most of us would have walked down that road, I’m sure. Whilst, some…
Learn All About Visualforce in Salesforce - The Complete Guide
Introduction With the help of the web development framework Visualforce, programmers may create complex, unique user interfaces for desktop and mobile apps that can be…
Improve your Apex Code Unit | Salesforce Best Practices
In this blog, we are going to discuss the best practice of Apex. Apex code is used to write custom business logic. in any language,…
Popular Salesforce Videos
Salesforce Marketing Cloud Automation Studio
Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis. Use Automation…
Salesforce Heroku Integration | Heroku Connect
Heroku is a cloud platform that lets deploy, run and manage applications and websites. It is part of Salesforce Platform. This video will explain about…
Top 5 Benefits of Salesforce Financial Service Cloud
Built on the Salesforce Customer Success Platform, Financial Services Cloud includes an enhanced set of features created specifically for client engagement and designed with the…
