I am not new to SQL, but I am new to SOQL.  I have a custom field in the user object that I cannot reach with owner.<custom field>

I've been researching how to do this, and I still have yet to figure out a solution.  Is there no way for me to access it in a query?  

An example query I need to work is this:

SELECT id, name, owern.name, owner.<custom field> FROM lead WHERE id = <my value>

Can anyone tell me the correct syntax, or confirm it is "impossible" with SOQL?  Is there an alternative using SOSL if so?



 

I am not new to SQL, but I am new to SOQL.  I have a custom field in the user object that I cannot reach with owner.<custom field>

I've been researching how to do this, and I still have yet to figure out a solution.  Is there no way for me to access it in a query?  

An example query I need to work is this:

SELECT id, name, owern.name, owner.<custom field> FROM lead WHERE id = <my value>

Can anyone tell me the correct syntax, or confirm it is "impossible" with SOQL?  Is there an alternative using SOSL if so?