-
How to retrieve data from multiple Objects in one query ?
How to retrieve data from multiple Objects in one query ?
-
2 Replies
-
SELECT (SELECT Obj1__r.Name FROM Junction1__r),
(SELECT Obj3__r.Name FROM Junction2__r),
Name
FROM Obj2__c
WHERE Id IN (SELECT Obj2__c FROM Junction1__c WHERE Obj1__c = 'some-id-here') - [adinserter block='9']
-
SELECT (SELECT Obj1__r.Name FROM Junction1__r),
(SELECT Obj3__r.Name FROM Junction2__r),
Name
FROM Obj2__c
Log In to reply.
Popular Salesforce Blogs
Reimagining User Experience with Salesforce to Drive a Better Customer Experience
The end user delivering the service must be the first objective in the pursuit of a better customer experience. This is especially true for any…
Ultimate Guide for Record Types in Salesforce
As an #AwesomeAdmin, we must ensure a great customization experience for our Users. Record Types is a core topic for an Admin to learn but…
5 Salesforce Lightning Features You're Missing Out On
Personalities praised for being bold, unique and intuitive deserve a working environment that reflects the same. Salesforce has transitioned from data entry focused on workflow…
Popular Salesforce Videos
What is Salesforce Apex Trigger | When to use Salesforce Apex Trigger | Type of Salesforce Apex Trigger
In this video, we are going to learn some basic concepts of Apex trigger. Below is the Agenda. Video Resource: SFDC Panther
Create a LinkedIn Page like a Salesforce Professional
In this first video of our series "How to Find a Job as a Salesforce Professional", Brad discusses how to create and modify your outdated…
Salesforce: How To Set Up Einstein Bot
With Einstein Bots, you can keep your service reps free from simple, repetitive tasks and they can spend more time on complex customer cases. If…
