Version : 14001

DB : PGSQL /  MSSQL

OUTPUT :

SELECT  ch.CHANGEID "Change ID",
ch.TITLE "Change Title",
rctd.FIRST_NAME "WorkLog Owner",
Longtodate(ct.TS_ENDTIME) "WorkLog END Time",
ct.DESCRIPTION,
chfd.UDF_DATE2 AS "Signature Date" FROM ChargesTable ct
LEFT JOIN ChangeToCharge chtoc ON ct.CHARGEID=chtoc.CHARGEID
LEFT JOIN ChangeDetails ch ON chtoc.CHANGEID=ch.CHANGEID
LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID
LEFT JOIN  TaskDetails tk ON tkc.TASKID=tk.TASKID
LEFT JOIN ChangeToTaskDetails ctk ON tk.TASKID=ctk.TASKID
LEFT JOIN SDUser rcti ON ct.technicianid=rcti.USERID
LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID
LEFT JOIN Change_Fields chfd ON ch.CHANGEID=chfd.CHANGEID order by ch.CHANGEID,chfd.UDF_DATE2,ct.TS_ENDTIME DESC