Hello everyone i want to equal between reportname in custom object between report name in standard object
what is the problem here?
This is my query:
Select Id, Name, Report_ID__c, Attachment_Name__c, Email_Subject__c, Email_Body__c, Email_Recipients__c, Frequency__c, Weekly_Days__c, Monthly_Day__c, Last_Ran__c, reportname__c from Exporter__c where reportname__c in (select name.id from report)
This is my error:
where reportname__c in (select name.id from report) ^ ERROR at Row:2:Column:33 Didn't understand relationship 'name' 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.
Need help here with this query
Thank you very much.