-
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 Apex Trigger
By using Apex triggers, you may execute custom code before and after specific Salesforce record events, such as inserts, changes, and deletes. Apex offers trigger…
Why to Hire a Salesforce Partner Company for Salesforce Project?
While you can implement Salesforce on your own, hiring an outside Salesforce specialist is often the best way to ensure the project is completed on…
7 Rules for a Better Salesforce Development
Salesforce ventures require arranging your application and at times creating code. To guarantee execution, practicality and stage limits, you have to do the correct design…
Popular Salesforce Videos
Manage Record Access and Visibility in Salesforce
Watch this video to learn all about managing record access and visibility in Salesforce. Do let us know in the comment section if you have…
The Rise of Salesforce
Salesforce is a cloud computing service as a software (SaaS) company that specializes in customer relationship management (CRM). Salesforce's services allow businesses to use cloud…
How to Integrate QuickBooks with Salesforce?
QuickBooks and Salesforce are two of the most used cloud based software. They are used by small to large scale companies alike and the integration…
