the following query lists all individual Requests by the Requesters name:

SELECT aau.FIRST_NAME AS "Requester" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((std.STATUSNAME = 'Onhold') OR (std.STATUSNAME = 'Open'))  AND wo.ISPARENT='1'

How would I amend the above to include the the Email of that Requester instead of the name.

Any help on this would be much appreciated,

Many thanks

Glenn