Why is this statement wrong? I got an error when executing this statement in developer console.
SELECT Id, Account_Name__r.Name, Account__r.Account_No__c From CBR__c
CBR_ is a child object to Account and Account_Name__c is a lookup field to Account.
SELECT Id, Account_Name__r.Name, Account__r.Account_No__c From CBR__c ^
ERROR at Row:1:Column:34
Didn't understand relationship 'Account__r' in field path. 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.