Dear all,
 
 I want a report where the Technician is the same person of the requester.
 
 I try with this but the i have a strange result. can we help me?
 
 SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",cd.CATEGORYNAME "Category",pd.PRIORITYNAME "Priority",wo.TITLE "Subject",LONGTODATE(wo.CREATEDTIME) "Created Time",LONGTODATE(wo.COMPLETEDTIME) "Completed Time",std.STATUSNAME "Request Status",ApprovalDetails.EMAIL "Approver Email",LONGTODATE(ApprovalStage.SENT_DATE) "Approval Sent date",LONGTODATE(ApprovalDetails.ACTION_DATE) "Approved Date",ApprovalStatusDefinition.STATUSNAME "Approval Status",ApprovalDetails.COMMENTS "Comments" 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 CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 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_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID JOIN ApprovalStageMapping ON wo.WORKORDERID=ApprovalStageMapping.WORKORDERID LEFT JOIN ApprovalDetails ON ApprovalStageMapping.APPROVAL_STAGEID=ApprovalDetails.APPROVAL_STAGEIDLEFT JOIN ApprovalStage ON ApprovalDetails.APPROVAL_STAGEID=ApprovalStage.APPROVAL_STAGEID LEFT JOIN  approvalstatusdefinition ON ApprovalDetails.STATUSID=ApprovalStatusDefinition.STATUSID   WHERE aau.FIRST_NAME = ti.FIRST_NAME