-
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
Salesforce Automation — Business Cases
In this series of articles about Salesforce Automation, we have explained and demonstrated how each of the automation tools can be used and provided an…
Guide to Install an App from AppExchange
Thank you for your interest in knowing how to install apps from AppExchange for Salesforce. Use my blog as a guide, it will help you…
Benefits of Salesforce CRM for Insurance Company
In today’s dynamic market, insurance companies need more than just adaptability to stay competitive – they must innovate for long-term success. A powerful tool in…
Popular Salesforce Videos
How To Change Opportunity Stages In Salesforce
If you're finding that you need to change the stages of opportunity in Salesforce, don't worry, it's easy to do. In this video, Gary Smith…
How can Salesforce Field Service Help in Providing a Better Customer Experience?
Salesforce Field Service Management automates and optimizes the work of field service workers (agents, dispatchers, mobile technicians). It is part of the Service Cloud and…
Update Record Using Salesforce Flow | Flow Builder Series Salesforce
In this video, we will learn how to use Update Records in Salesforce Flow. Here is the timestamp for your help. ----------------- Update Records in…
