Unnamed

UPDATE
        C3_Stats3 AS s3 
       	JOIN (
               	SELECT
                        s.SR_Number,
                        SR_Activity_User_CCO_ID AS SLA_Initial_Contact_CCO_ID,
                        SR_Activity_User_Workgroup AS SLA_Initial_Contact_Workgroup
               	FROM
                        C3_Stats s
               	JOIN (
                       	SELECT
                                MIN(SR_Activity_Timestamp),
                                SR_Number,
                                SR_Activity_User_Workgroup,
                                SR_Activity_User_CCO_ID
                       	FROM
                               	C3_Notes
                       	WHERE
                                SR_Activity_Code = '9200'
                       	GROUP BY
                                SR_Number
                ) t1 ON t1.SR_Number = s3.SR_Number
               	WHERE
                        SLA_Initial_Contact_CCO_ID = 'XXCTS_SRM_ADMIN_PROCESS'
        ) t1 ON s3.SR_Number = t1.SR_Number
SET
        s3.SLA_Initial_Contact_CCO_ID = t1.SLA_Initial_Contact_CCO_ID,
        s3.SLA_Initial_Contact_Workgroup = t1.SLA_Initial_Contact_Workgroup 
WHERE
        s3.SLA_Initial_Contact_CCO_ID = 'XXCTS_SRM_ADMIN_PROCESS'