Version : 14200

DB : MSSQL / PGSQL

OUTPUT :

Query :

select wo.workorderid AS "Request ID",
wo.title AS "Subject",
wotodesc.FULLDESCRIPTION AS "Description" from pmtasktoworkorder pmtw
INNER JOIN workorder wo ON pmtw.WORKORDERID=wo.WORKORDERID
LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID