Version : 10609

DB : MSSQL & PGSQL

OUTPUT:

SELECT wo.WORKORDERID AS "Request ID",longtodate(srm.responsetime) AS "Responded Date", longtodate(srm.SENDTIME) AS "Survey Created Time", smn.SURVEYNAME AS "Survey Name", AaaLogin.NAME AS "Username Received By",aau.FIRST_NAME AS "Survey Answered By" FROM SurveyResponseRequestMapping srrm INNER JOIN Survey_Response_Main srm ON srrm.RESPONSEID=srm.RESPONSEID LEFT JOIN Survey_Main smn ON srm.SURVEYID=smn.SURVEYID LEFT JOIN WorkOrder wo ON srrm.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN AaaLogin ON aau.USER_ID = AaaLogin.USER_ID where smn.SURVEYNAME = 'testa'