SELECT accountid, name, account.name, account.edit_date_funded__c, account.createddate, date_lead__c, ln_score_again__c, createddate, lead.ln_score__c FROM Opportunity WHERE accountid IN (select id from account) AND accountid IN (select convertedaccountid from lead)
I get an error for lead.ln_score__c or when I try to select anything from lead.
"Didn't understand relationship 'lead' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name."
Can someone tell me what I need to fix.