SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details "Shipping_details", cri.FIRST_NAME "Created By", aau.FIRST_NAME "Requester", ti.FIRST_NAME "Technician", pd.PRIORITYNAME "Priority", std.statusname "Status", (aaa.FIRST_NAME) "Approver", (pos1.STATUSNAME) "PO Approval Status", LONGTODATE(poa1.APPROVAL_DATE) "Approval Date" FROM purchaserequest pr LEFT JOIN SDUser sdu ON pr.Requestedby=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SDUser crd ON pr.Createdby=crd.USERID LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID LEFT JOIN SDUser td ON pr.Technicianid=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON pr.PRIORITYID=pd.PRIORITYID LEFT JOIN POStatus std ON pr.statusid=std.statusid LEFT JOIN PRLevelInfo pol ON pr.requestid=pol.requestid LEFT JOIN PurchaseApprovalDetails poa1 ON pol.LEVELINFOID=poa1.LEVELINFOID LEFT JOIN AaaUser aaa ON poa1.APPROVERID=aaa.USER_ID LEFT JOIN levelinfo li ON pol.LEVELINFOID=li.LEVELINFOID LEFT JOIN POApprovalStatus pos1 ON li.LEVELSTATUSID=pos1.STATUSID ORDER BY 1