Please add to this query the JOIN that allows us to show the PROJECTID, and Project Code and Project Title

SELECT wof.UDF_CHAR1 "PPM #",wo.WORKORDERID "Request ID",wof.UDF_CHAR2 "Ticket Type",std.STATUSNAME "Request Status",wof.UDF_CHAR6 "PMO Status",wof.UDF_CHAR14 "PMO Sub Status",scd.NAME "Subcategory",pd.PRIORITYNAME "Priority",wof.UDF_CHAR10 "Severity",aau.FIRST_NAME "Requester",ti.FIRST_NAME "Technician",wo.TITLE "Subject",wo.CREATEDTIME "Created Time",wof.UDF_DATE7 "QA Delivery Date",wof.UDF_DATE8 "Staging Delivery Date",wof.UDF_DATE6 "MTP Cutoff Date",wof.UDF_DATE5 "Production Delivery Date" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE  ((((((((wof.UDF_CHAR2 = N'Defect' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (wof.UDF_CHAR2 = N'Project' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'Research/Investigation' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'Support' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'Table Change' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'User Role' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'User Training' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (wof.UDF_CHAR2 = N'Work Request' COLLATE SQL_Latin1_General_CP1_CI_AS))  AND wo.ISPARENT='1'