SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",aaacontact.EMAILID "Email"  FROM surveyperrequest sr 

LEFT JOIN workorder wo ON wo.WORKORDERID=sr.WORKORDERID  

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID 

LEFT JOIN AaaUserContactInfo aaausercontact ON aau.USER_ID=aaausercontact.USER_ID 

LEFT JOIN AaaContactInfo aaacontact ON aaausercontact.CONTACTINFO_ID=aaacontact.CONTACTINFO_ID 

WHERE sr.SURVEYID NOT IN (SELECT surveyid FROM surveyperrequestext)