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

8

DAYS :

10

HOURS :

58

MINS :

27

SECONDS
vote

For Standard Objects:

SELECT (SELECT child_obj_field FROM child_relationship_name) FROM parent_object;

List<Account> accList = [select name, numberOfEmployees, (select name, amount,

closeDate from opportunities) from Account];

  for(Account a: accList)

  {

System.debug(‘ACC: ’ + a.name + ’ NoEMpl: ’+a.numberOfEmployees.;

List<Opportunity> oplist = a.opportunities;

for(opportunity o: oplist)

{

System.debug(‘opportunity name:’ + o.name + ‘Amount: ’+a.amount);

}

  }

For Custom Objects:

SELECT (SELECT child_obj_field FROM (child_relationship_name)__r)

FROM parent_object;

List<Bank__c> bankList = [select Bank_Name__c, (select Branch_ID__c, Name,

State__c from Branches__r) from Bank__c];

for(Bank__c ba: bankList)

{

List<Branch__c> branchList = ba.branches__r;

for(Branch__c br: branchList)

{

System.debug(‘Bank:’+ba.Bank_Name__c+’|Branch ID:’+br.Branch_ID__c

+’|Branch Name:’+br.Name+’|Branch State:’+br.State__c);

       }

}

Note: You can not write a subquery inside a subquery in SOQL.

 

 

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
×