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
	SET s3.SLA_Initial_Contact_CCO_ID = t1.SLA_Initial_Contact_CCO_ID
WHERE 
	s3.SLA_Initial_Contact_CCO_ID = 'XXCTS_SRM_ADMIN_PROCESS'
 	AND s3.SR_Number = t1.SR_Number