function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jameskCAjameskCA 

SOQL query on Lead Owner fields from User object?

I know there are a limited amount of fields you can access using the owner relationship on lead.  What I haven't seen is if there is a workaround to access the user fields based on the ownerid?  

I have a proposal custom object that has a lookup field to a lead.  I need to create a SOQL statement to get sevearl user field values where the user is the owner of the lead related to the proposal.  

I'm doing this in drawloop, so I can only do a SOQL query - I don't think I can use any other code.  Is there a single SOQL statement that can do this? Thanks in advance.