I am trying to write a SOQL query that will return Opportunity information and also get fields from the User Object where the User is the Opportunity Owner. I am trying to pull in the user's profile photo URL.
The below SOQL does not work, but I am showing it to illustrate what I hope to do.
SELECT Id, Name, StageName, CloseDate, Owner.Id (SELECT FullPhotoUrl FROM User) FROM Opportunity
How can I modify or write the SOQL query to return Opportunity information and fields from the User object who owns the Opportunity?