I have a report that will show me how much time a tech enters against a request ( see query below)  How can I enhance this query to also show how much time is spent on a change request.

 

SELECT rc.DATETIME "Cost entry date",wo.WORKORDERID "Request ID",wo.TITLE "Subject",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",rc.MM2COMPLETEREQUEST "Time Elapsed" FROM WorkOrder wo LEFT JOIN RequestCharges rc ON wo.WORKORDERID=rc.WORKORDERID LEFT JOIN RCTechnicianIDs rct ON rc.REQUESTCHARGEID=rct.REQUESTCHARGEID LEFT JOIN SDUser rcti ON rct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID 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 StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((rctd.FIRST_NAME = N'Johnson, Karen' COLLATE SQL_Latin1_General_CP1_CI_AS) AND (((rc.DATETIME >= 1316923200000) AND ((rc.DATETIME != 0) AND (rc.DATETIME IS NOT NULL))) AND ((rc.DATETIME <= 1317527999000) AND (((rc.DATETIME != 0) AND (rc.DATETIME IS NOT NULL)) AND (rc.DATETIME != -1)))))  AND wo.ISPARENT=1  ORDER BY 1,  wo.RESPONDEDTIME,  rc.EXECUTEDTIME, 4