+ Start a Discussion
Devendra Hirulkar 3Devendra Hirulkar 3 

querry shows an error

Hi all 
in my below querry the following error shows 
ERROR at Row:1:Column:68
Didn't understand relationship 'Subscriptions__r' 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.

in the below qureey
(SELECT id, Product_Name__c,(SELECT ID, membership_type_del__c FROM Subscriptions__r) FROM Account)
thanks 
please replies me fast friends
Saravanan @CreationSaravanan @Creation
Hi,

Please provide me the answer for below question

Whether Subscriptions is your custom object or not?
Is it related with Account(1 to M) Subscriptions many relationship?
What is the plural name of you Subscriptions object?

Reference query:
SELECT id, (SELECT ID FROM contacts) FROM Account
 
Devendra Hirulkar 3Devendra Hirulkar 3
yes subscriptions is my custom object
one to one relationship
(Subscriptions) it is plural name of my subscription obj