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", pr.Comments "Comments", cri.FIRST_NAME "Created By", aau.FIRST_NAME "Requester", ti.FIRST_NAME "Technician", pd.PRIORITYNAME "Priority", std.statusname "Status", pxt.QUANTITYORDERED "Quantity of Items", cd.COMPONENTNAME "Product" 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 PRPOAssociation prpo ON pr.requestid=prpo.requestid LEFT JOIN Purchaseorderext pxt ON prpo.PURCHASEORDERID=pxt.PURCHASEORDERID LEFT JOIN ComponentDefinition cd ON pxt.COMPONENTID=cd.COMPONENTID