Merging 2 reports
I would like to merge the following 2 queries together, please can you help>>
SELECT wo.workorderid 'RequestID',wo.TITLE 'Subject',rtd.name 'RequestType',aau.FIRST_NAME 'Requester',cd.CATEGORYNAME 'Category',scd.NAME 'Sub Category',dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Created Time',dateadd(s,wo.COMPLETEDTIME/1000,'01-01-1970') 'Completed Time',ti.FIRST_NAME 'Technician',pd.PRIORITYNAME 'Priority',dateadd(s,wo.DUEBYTIME/1000,'01-01-1970') 'Dueby Time' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID 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 CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 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 requesttypedefinition rtd on rtd.requesttypeid=wos.requesttypeid WHERE (wot.THD_WOID=wot.WORKORDERID) and wos.requesttypeid != ''
SELECT cd.CATEGORYNAME "Category",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",cd.CATEGORYNAME "Category",wo.CREATEDTIME "Created Time",wo.TITLE "Subject",qd.QUEUENAME "Group",scd.NAME "Sub Category",cri.FIRST_NAME "Created By",pd.PRIORITYNAME "Priority",wo.DESCRIPTION "Description",wof.UDF_CHAR2 "Customer" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SDUser crd ON wo.CREATEDBYID=crd.USERID LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE (((wo.CREATEDTIME >= 1193835600296) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1230641999296) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Cheers
Sylvon
SELECT wo.workorderid 'RequestID',wo.TITLE 'Subject',rtd.name 'RequestType',aau.FIRST_NAME 'Requester',cd.CATEGORYNAME 'Category',scd.NAME 'Sub Category',dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Created Time',dateadd(s,wo.COMPLETEDTIME/1000,'01-01-1970') 'Completed Time',ti.FIRST_NAME 'Technician',pd.PRIORITYNAME 'Priority',dateadd(s,wo.DUEBYTIME/1000,'01-01-1970') 'Dueby Time' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID 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 CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 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 requesttypedefinition rtd on rtd.requesttypeid=wos.requesttypeid WHERE (wot.THD_WOID=wot.WORKORDERID) and wos.requesttypeid != ''
SELECT cd.CATEGORYNAME "Category",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",cd.CATEGORYNAME "Category",wo.CREATEDTIME "Created Time",wo.TITLE "Subject",qd.QUEUENAME "Group",scd.NAME "Sub Category",cri.FIRST_NAME "Created By",pd.PRIORITYNAME "Priority",wo.DESCRIPTION "Description",wof.UDF_CHAR2 "Customer" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SDUser crd ON wo.CREATEDBYID=crd.USERID LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE (((wo.CREATEDTIME >= 1193835600296) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1230641999296) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Cheers
Sylvon