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.