Nested SOQL Relationships

Document created by butlerj Support on Dec 18, 2018
Version 1Show Document
  • View in full screen mode
TOPIC
How to write a nested SOQL relationship.
INSTRUCTIONS
The following example illustrates a nested SOQL relationship:
SELECT Id, Name, Client__r.Name, Client__r.Client_Type__c, Client__r.Monthly_Fee__c,  (SELECT Id, Risk_Year__c FROM Vendor_Checklist__r WHERE Vendor_Relationships__c = '>'),  (SELECT Id, Vendor_Product__r.Name FROM Relationship_Products__r WHERE Vendor_Relationship__c ='>')  FROM Vendor_Relationships__c WHERE Vendor__c = '>'
ADDITIONAL INFORMATION
RELATED LINKS

Attachments

    Outcomes