I have a query and I need to do a subQuery on it, I have tryed everything but I don't find the way to make it work.
select id, Name, parentField__c, (Select id, name, Childfield__c from ChildObject__c) from ParentObject__c where ParentObject__c = :varToFilter
The error is:
Didn't understand relationship 'ChildObject__c' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
What should I do to make it work.