I am new to salesforce, I am using the below query to fetch data from Salesforce Approval Process, Here actorId is the Id which matches with the Id of User table. I need User email from the User table along with below values in the query. How can i do that?
SELECT SystemModstamp, Createddate, actorId, processinstance.status, processInstance. targetobjectid FROM ProcessInstanceWorkitem