select id,name,Number_of_Subscriptions__c,(Select id from Subscriptions) from Contract
In the above scenario, Contract is parent object and Subscription is child object having lookup relationship.
The child-relationship name is "Subscriptions". But i am trying to execute above query it showing me error:
ERROR at Row:1:Column:54 Didn't understand relationship 'Subscriptions' 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.
I tried using __r also:
select id,name,Number_of_Subscriptions__c,(Select id from Subscriptions__r) from Contract
doesn't worked out!!
Any kind of help is appreciated!!