-
How to perform inner query in SOQL (Salesforce Object Query Language)?
How to perform an inner query in SOQL (Salesforce Object Query Language)?
-
2 Replies
-
Hi Ankit,
You need the relationship name to perform inner SOQL query. For example, if you are going to perform a query to get Accounts along with their contacts then your query will be something like -
Select Id, Name,(Select Id, LastName from Contacts) from Account.
Where Contacts is the relationship name between Account and Contact.
Hope this helps,
Thanks,
Subhendu
-
Hi Ankit ,
Here is the example of inner SOQL query(parent to child ) -(Account and contact)
[SELECT ID , Name, (SELECT id FROM Contacts ) FROM Account ]
Log In to reply.
Popular Salesforce Blogs
Salesforce Communities and Licenses
# BENEFITS OF COMMUNITIES: 1. Save Time By creating a community platform for customers to share, you give your customers access to not only your…
Salesforce Marketing Cloud Connect
Marketing Cloud Connect allows Salesforce users to leverage the advanced marketing power of the Marketing Cloud and the customer relationship tools in Sales and Service…
Value of Salesforce in Small and Medium Business
Speed is the quintessence of the business world. That is valid for almost every part of our business, yet it's particularly valid for innovation and…
Popular Salesforce Videos
Passed Salesforce Certification Exam in First Attempt
Salesforce certifications come in all shapes and sizes, so nearly anyone who works in Salesforce and wants to learn more about the tool can find…
Salesforce Pardot Basics - A Comprehensive Guide (2021)
In this short video, we will cover the basics of Salesforce Pardot Pardot by Salesforce is a demand generation and marketing management tool by Salesforce.…
How to Log an Admin Assist Support Case in Help and Training in Salesforce Help
Do you need to log a case with Admin Assist Salesforce Support but aren't sure how to go about it? Do you need help filling…
