Activity Forums Salesforce® Discussions How to retrieve data from multiple Objects in one query ?

  • How to retrieve data from multiple Objects in one query ?

    Posted by Kirandeep on May 20, 2020 at 10:44 AM

    How to retrieve data from multiple Objects in one query ?

    Pooja replied 6 years ago 3 Members · 2 Replies
  • 2 Replies
  • MOHIT

    Member
    May 20, 2020 at 3:22 PM

    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']
  • Pooja

    Member
    May 20, 2020 at 3:56 PM

    SELECT (SELECT Obj1__r.Name FROM Junction1__r),
    (SELECT Obj3__r.Name FROM Junction2__r),
    Name
    FROM Obj2__c

Log In to reply.