approver's name & email

approver's name & email

Hello.

please help.

I need to include in this query the email address and the name of the approver of each of the requests.



SELECT 
"wo"."WORKORDERID" AS "ID de la solicitud", 
"rtdef"."NAME" AS "Tipo de solicitud", 
"cd"."CATEGORYNAME" AS "Categoría", 
"scd"."NAME" AS "Subcategoría", 
"wotodesc"."FULLDESCRIPTION" AS "Descripción", 
"appStDef"."STATUSNAME" AS "Estado de la aprobación"  
FROM 
"WorkOrder" "wo" 
LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID" 
LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" 
LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID"="cd"."CATEGORYID" 
LEFT JOIN "SubCategoryDefinition" "scd" ON "wos"."SUBCATEGORYID"="scd"."SUBCATEGORYID" 
LEFT JOIN "RequestTypeDefinition" "rtdef" ON "wos"."REQUESTTYPEID"="rtdef"."REQUESTTYPEID" 
LEFT JOIN "ApprovalStatusDefinition" "appStDef" ON "wos"."APPR_STATUSID"="appStDef"."STATUSID" 
WHERE  
(((("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Approved') 
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Denied')) 
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Pending Approval')) 
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'To Be Sent'))  
AND wo.ISPARENT='1'  
ORDER BY 6

                  New to ADSelfService Plus?