UPDATE [FORDCPOLINKEDSERVER].[FORDCPO].[DBO].ANNOUNCEMENTS
SET
	ISREAD = 1,
	READDATETIME = GETDATE()
WHERE
	ANNOUNCEMENTID IN
	(
	SELECT
		ANNOUNCEMENTID
	FROM
		[FORDCPOLINKEDSERVER].[FORDCPO].[DBO].ANNOUNCEMENTS A
		JOIN
			[FORDCPOLINKEDSERVER].[FORDCPO].[DBO].INSPECTIONS i
		ON A.INSPECTIONID = I.INSPECTIONID
	WHERE
		ISREAD = 0
		AND i.CERTIFICATIONSTATUS > 4
	)