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