Learn from industry experts! Admin batch starts from 19 Feb.
Hurry up!
Book your slot now!

6

Child to Parent Relationship

What Is SOQL Relationship Queries?

Relationship queries involve at least two objects, a parent and a child. These queries are used to fetch data either from the Parent object when the SOQL query is written on the child, or from the child object when the SOQL query is written on the parent.

ServiceNow Webinar CTA

What Is Child To Parent Query In Salesforce?

Whenever we need to fetch data from parent object fields with child records, we use the query child-to-parent.

For Standard Objects

 SELECT Field_Name.Parent_Obj_Field FROM Child_Object;
List < Opportunity > oppList = [SELECT Name, Amount, CloseDate, Account.Name
    FROM Opportunity
];
for (Opportunity o: oppList) {
    System.debug('Opp: ' + o.Name + ' Acc: ' + o.Account.Name);
}

For Custom Objects

SELECT(Field_Name) __r.Parent_Obj_Field FROM child_object;
List < Branch__c > branchList = [SELECT Branch_ID__c, State__c,
    Branch_of_Bank__r.Bank_Name__c from Branch__c
];
for (Branch__c bl: branchList) {
    System.debug('Bank Name: ' + bl.Branch_of_Bank__r.Bank_Name__c + 'Branch: ' + bl.State__c);
}
Next Topic

Need more support?

Get a head start with our FREE study notes!

Learn more and get all the answers you need at zero cost. Improve your skills using our detailed notes prepared by industry experts to help you excel.

Book A 15-Minutes Free Career Counselling Today!