I'm trying to query using a very basic line of code. I have a lookup relationship from Account to a custom object (1:1 or 1:many). Below is the query;
SELECT id, (SELECT channel__r.name,channel__r.account_cohort__c From channel__r) from Marketplace__c
Can anyone help me update this code. Essentially I want the custom object marketplace__c with fields from the account that is a lookup field on the marketplace object. For some reason, the account object is referenced as channel__r on the marketplace.