SELECT srcmt.COMMENTTEXT AS "Comments", to_timestamp(srm.SENDTIME/1000) AS "Survey Created Time", sq.QUESTEXT AS "Survey Question", sra.ANSWER AS "Rating", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", sra.VALUE AS "Rating Value" FROM SurveyResponseRequestMapping srrm INNER JOIN Survey_Response_Main srm ON srrm.RESPONSEID=srm.RESPONSEID LEFT JOIN Survey_Response_Answer sra ON srm.RESPONSEID=sra.RESPONSEID INNER JOIN Survey_Question sq ON sra.QUESID=sq.QUESID LEFT JOIN Survey_Response_Comment srcmt ON srm.RESPONSEID=srcmt.RESPONSEID 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