-
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
Here’s what makes Field Service Lightning the fastest growing product of Salesforce
In the era of Digital Transformation, Customer Experience (CX) is the new battleground, and delivering superior CX has never been more important. In fact, according to…
Optimizing Fleet and Delivery Management with Salesforce and IoT Tracking Integration
Fleet and delivery management has become more complex due to rising consumer expectations, fuel costs, and logistics disruptions. In fact, according to Deloitte, 79% of…
Omni-channel setup in quick 15 minutes…
Omni-Channel enables your contact center to push work to the most qualified, available support agent in your organization in real time. Omni-Channel lets you create work…
Popular Salesforce Videos
Launch of Virtual Sales Tools | Salesforce 360: New Features
Salesforce has announced new Sales Cloud and supporting features to make virtual sales experiences more engaging and productive. In a nutshell, Salesforce is releasing 4…
Journey To A Salesforce Solution Architect
A Salesforce Solution Architect must master a number of skills to be able to solve complex business requirements. In this session, we will cover 10…
How to Add Custom Fields on Custom Object in Salesforce?
Watch this video to learn all about how to add custom fields on custom objects in Salesforce. If you have any doubts do let us…
