Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", pr.SHIPPING_DETAILS AS "Shipping Details", au.FIRST_NAME AS "Created By", req_au.FIRST_NAME AS "Requested By", tec_au.FIRST_NAME AS "Technician", prp.NAME AS "Priority", pos.STATUSNAME AS "Status", pri.ITEMNAME AS "Product", pri.QUANTITY AS "Quantity Of Items" FROM PurchaseRequest pr LEFT JOIN SDUser sdu ON pr.CREATEDBY = sdu.USERID LEFT JOIN AAAUser au ON sdu.USERID = au.USER_ID LEFT JOIN SDUser req_sdu ON pr.REQUESTEDBY = req_sdu.USERID LEFT JOIN AAAUser req_au ON req_sdu.USERID = req_au.USER_ID LEFT JOIN SDUser tec_sdu ON pr.TECHNICIANID = tec_sdu.USERID LEFT JOIN AAAUser tec_au ON req_sdu.USERID = tec_au.USER_ID LEFT JOIN PRPriority prp ON pr.PRIORITYID = prp.PRIORITYID LEFT JOIN POStatus pos ON pr.STATUSID = pos.STATUSID LEFT JOIN PRRequestedItems pri ON pr.REQUESTID = pri.REQUESTID