-
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') -
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
Schedule Your Path in Salesforce Flow | Developer Guide
Advantages of Flow Builder over Process Builder Process builder does work on delete the records Flow work on a different object while Process Builder only…
Achieve Your Organization's Mission With Slack and Salesforce
To begin, NPOs can use Slack to bring their teams together by exchanging messages, insights, and information in personal discussions or designated "networks." Your channels…
Salesforce Marketing Cloud Hacks You Must Try
For any Marketing Cloud professional, it is important to know the ins and outs of the product so it can be used to its full…
Popular Salesforce Videos
CEPTES’s successful visit to Dreamforce’17
Thank you all to those who visited CEPTES at Dreamforce’17. It had been a great event and CEPTES would like to offer gratitude to our…
Build Your First Custom App On Salesforce
Lightning App Builder makes it super simple to quickly assemble apps using just declarative drag and drop features. This video covers how to upgrade a…
How to Set Up Salesforce Customer Community
Step by Step Salesforce tutorial for quickly setting up a Customer Community with Customer Service (Napili) Template.