Hi All New to SOQL wanted a little help so I can move forwards. I have a Master object called Application and 2 CHILD objects associated by MD (master detail) 1. Funding 2. Supplier I want to fetch records from both related lists via a SOQL query. Its giving me a parsing error. Im not sure on the exact syntax to query for multiple related objects where both are Master detail. I tried following the blog by a SF MVP, but attempt was futile. Please can a developer help with this very simple query (for a dev of course)
SELECT Id, Name, Minimum_Amount_Required__c , Case_Worker__c, (SELECT Funding_Amount__c FROM FROM Funding_Company__r), (SELECT Name, RecordTypeId FROM Supplier__r WHERE RecordTypeId = '012240000005vya') FROM Application__c WHERE Status__c='Surveyors'
Hi All New to SOQL wanted a little help so I can move forwards. I have a Master object called Application and 2 CHILD objects associated by MD (master detail) 1. Funding 2. Supplier I want to fetch records from both related lists via a SOQL query. Its giving me a parsing error. Im not sure on the exact syntax to query for multiple related objects where both are Master detail. I tried following the blog by a SF MVP, but attempt was futile. Please can a developer help with this very simple query (for a dev of course)
SELECT Id, Name, Minimum_Amount_Required__c , Case_Worker__c, (SELECT Funding_Amount__c FROM FROM Funding_Company__r), (SELECT Name, RecordTypeId FROM Supplier__r WHERE RecordTypeId = '012240000005vya') FROM Application__c WHERE Status__c='Surveyors'
