Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MoMo 

soql query downwards

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)

http://www.sfdc99.com/2013/06/24/example-how-to-write-a-cross-object-soql-query-part-2/

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'

sfdcsushilsfdcsushil
Your query looks ok. what is the exact error you see? And if you got master detail field on child object, you should see exact object name to use under field - Child Relationship Name. So if Child Relationship Name is  Funding_Company, then just append __r after it and use it in query. 
MoMo
Thanks @SFDCSUSHIL
It gives me an unknown parsing error. Can you help give me an example from a query you have done which is similair? 
I tried what you suggested but it still did not work unfortunately. 
Would be great if you could advise further please?