I am using the following code to report on open tasks per user. However, I now have a request to show open AND closed tasks for OPEN requests. The query below only brings back open tasks on open requests. Can someone help me get closed requests on open requests too? 

SELECT wo.WORKORDERID "Request ID",wo.DESCRIPTION "Description",td.TASKID "TaskId",td.TITLE "Task Title",td.description 'Description',au1.FIRST_NAME "Task Owner",sd.statusname 'Status',DATE_FORMAT(FROM_UNIXTIME(td.createddate/1000) ,'%d-%m-%Y %k:%i') "Created Date", DATE_FORMAT(FROM_UNIXTIME(td.scheduledendtime/1000) ,'%d-%m-%Y %k:%i') "Schedule End time",aau.FIRST_NAME "created by" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos on wos.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrdertoTaskDetails wtt on wtt.WORKORDERID=wo.WORKORDERID LEFT JOIN TaskDetails td on td.TASKID=wtt.TASKID LEFT JOIN SDUser sdu on sdu.USERID=wo.REQUESTERID LEFT JOIN AaaUser aau on aau.USER_ID=td.createdby LEFT JOIN AaaUser au1 on au1.USER_ID=td.ownerid LEFT JOIN StatusDefinition sd on sd.STATUSID=td.STATUSID LEFT JOIN Notes no on no.WORKORDERID=wo.WORKORDERID WHERE (wot.THD_WOID=wot.WORKORDERID) and sd.STATUSNAME='open'