Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Nested SOQL Relationships

    How to write a nested SOQL relationship.

    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 = '>'
    • Was this article helpful?