+ Start a Discussion

SOQL Query on child related records

Hello Everyone,

I am new to salesforce development and need help on SOQL query.

We follow account hierarchy (Parent-Child relationship) and all opportunities which we create are associated with child accounts. Need help in querying all the opportunities of the child records which I want to show on parent record.


HI Rahul ,

In salesforce we have two different types of relationship query .

In salesforce Account is parent and Opportunity is child .  There are two way parent to child and child to parent .

If parent to child then you need to write inner query .
If child to parent then you need to use relationship names in query .

Please check below link it will help .


Let me know incase you have any issue .

Hi Manoj,

Thanks for the info.

Actually, I want to query related objects of the child object on the parent object.

Here is the scenario:

Parent Account : A
Associated Child Accounts : Child A, Child B
Opportunities are associated with child A and B. 

Now, I want to write a query which provides all the opportunities associated with child accounts (Child A&B) of parent account A.
My actual requirement is to display all the child accounts opportunities, tasks on the parent account related list using VF page.


Rahul KumarRahul Kumar (Salesforce Developers) 
Hi Rahul,

May I request you please check the Salesforce documentation on  "SOQL Relationship Queries" check below link. Basic Examples of SOQL RELATIONSHIPS:
Child > Parent (Standard Object)
Selectid,Account.Name,Account.Phone,Account.industry,Account.Type,Account.Rating,Account.website,Account.Ownership,Account.AnnualRevenue,Account.NumberOfEmployees,Account.CleanStatus from Contact
Child >Parent(Custom Object)
Selectid,COLLEGE__r.Name,COLLEGE__r.Contact__c,COLLEGE__r.Count__c,COLLEGE__r.Highest_Marks__c,COLLEGE__r.Address__cfrom Studnt__c

Parent >Child(Standard object)
select Name, Industry, (select AssistantName, Email from contacts)from ACCOUNT
Parent >Child (Custom Object)
1select id,Name,(select Studnt__c.name__c from Studnts__r) from College__C

let us know if it helps.

Rahul Kumar