SELECT  bms_9999999_914.bms_ID AS [PSM Action Plan ID], R_R1_9999999_8616.bms_9999999_1231 AS [People to Notify Email Address] FROM  (( bms_9999999_914 LEFT JOIN bms_Component_Links  AS CLink_9999999_8616 ON ( bms_9999999_914.bms_ID = CLink_9999999_8616.bms_FromID AND CLink_9999999_8616.bms_RelationshipID='9999999_8616' )) LEFT JOIN bms_9999999_101 AS R_R1_9999999_8616 ON CLink_9999999_8616.bms_ToID=R_R1_9999999_8616.bms_ID )  WHERE  1=1