I am trying to query the child record using the parent record id. I understand that we have to use the child relation name in the inner query to get the child records.
select id, (select id from child_relationshipname__r ) from parentobjt__c
In my case I use the same way to query but I get the error :
ERROR at Row:1:Column:28
Didn't understand relationship 'cyx__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.
I am not sure why it is throwing error I doubled checked whether the child relationship name is correct.
select id, (select id from namespc.Impacted_Products__r) from MC_Product_Complaint__c