Master the concepts of Salesforce in just 45 days Click here to know more.

8

DAYS :

10

HOURS :

58

MINS :

27

SECONDS
vote

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 SOQL query is written on child, or from child object when SOQL query is written on parent.

Child to Parent:

For Standard Objects:

SELECT relationship_field.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 (relationship_field)__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);

  }

 

Cyntexa CTA

Our Recent Blog

Key Roles & Responsibilities Of A Salesforce Administrator

Key Roles & Responsibilities Of A Salesforce Administrator

19 Apr, 2022
Choosing a career as a Salesforce Administrator can be the best you can have because it will have a growing impact on the business.
Read More
How To Pass The Salesforce Developer Certification Exam?

How To Pass The Salesforce Developer Certification Exam?

17 Mar, 2022
Easy ways to crack salesforce developer program like learn basic coding, know prerequisites for salesforce developer certification, start practical exercises with trailhead.
Read More
Is Salesforce a Good Career?

Is Salesforce a Good Career?

01 Mar, 2022
Salesforce Developer Careers are on trending jobs across the globe. Start your career in Salesforce by taking Salesforce Developer Course, Admin Course.
Read More
Salesforce Career Choices In 2022 With Learning Path & Pay Scale

Salesforce Career Choices In 2022 With Learning Path & Pay Scale

27 Jan, 2022
There's no denying that the Salesforce economy is thriving right now. IDC predicts that 4.2 million jobs are being created...
Read More
The 2022 Salary Guide for Salesforce Developers

The 2022 Salary Guide for Salesforce Developers

25 Jan, 2022
Whenever a modern consumer needs more than simply a high-quality product or service, generating leads and converting them into loyal...
Read More
How To Pass The Salesforce Admin Certification Exam?

How To Pass The Salesforce Admin Certification Exam?

17 Jan, 2022
Salesforce is a critical component of the day-to-day operations of many businesses. The good news for Salesforce Admins is that...
Read More
Salary Guide Of Salesforce Consultant In 2022

Salary Guide Of Salesforce Consultant In 2022

13 Jan, 2022
Introduction: Before delving into the Consultancy part, let us understand what Salesforce is. Salesforce is the #1 CRM platform with...
Read More

Can I get a job by just learning Salesforce Admin?

30 Nov, 2021
In the 29th episode of the #AsktheHulk series Akarsh raised the question “Is there any opportunities for the Salesforce Admin?”
Read More
How the Salesforce Job Market is Growing

How the Salesforce Job Market is Growing

25 Nov, 2021
Introduction: Salesforce is considered to be the world’s most popular CRM platform while having at least a 20% market share,...
Read More
7 Best Salesforce Certifications In 2021

7 Best Salesforce Certifications In 2021

23 Nov, 2021
Introduction: Before moving towards the Best Salesforce Certification topic, let’s first understand about Salesforce, for those who are still unaware...
Read More
Share This Post
×