Add Linked Request number to Purchase Order Report

Add Linked Request number to Purchase Order Report

We currently have this query report, but want to add the Associated Service Request to the report. How do we do that?

SELECT "po"."PONAME" AS "PO Name", "po"."POCUSTOMID" AS "PO Number", "poaddfield"."UDF_CHAR6" AS "Customer Name", "poa"."FIRST_NAME" AS "Purchase Requester", "pos"."STATUSNAME" AS "PO Status", "po"."DATEORDERED" AS "Ordered Date", "poaddfield"."UDF_DATE3" AS "Date PO Received", "poaddfield"."UDF_DATE2" AS "Estimated Arrival Date", "po"."DATERECEIVED" AS "Received Date"  FROM "PurchaseOrder" "po" LEFT JOIN "POStatus" "pos" ON "po"."STATUSID"="pos"."STATUSID" LEFT JOIN "SDUser" "por" ON "po"."REQUESTERID"="por"."USERID" LEFT JOIN "AaaUser" "poa" ON "por"."USERID"="poa"."USER_ID" LEFT JOIN "PurchaseOrder_Fields" "poaddfield" ON "po"."PURCHASEORDERID"="poaddfield"."PURCHASEORDERID" ORDER BY 6

MSSQL
SDP 9306

                  New to ADSelfService Plus?