Preview:
UPDATE tbl_lab_setup_Test_Control 
SET Test_Blank_Result_Flag = 0 
WHERE
	Test_Code IN (
	SELECT
		tbl_lab_setup_Test.Test_Code 
	FROM
		dbo.tbl_lab_setup_Test_Control
		INNER JOIN dbo.tbl_lab_setup_Test ON tbl_lab_setup_Test_Control.Test_Code = tbl_lab_setup_Test.Test_Code 
	WHERE
		tbl_lab_setup_Test_Control.Test_Blank_Result_Flag = '1' 
	AND tbl_lab_setup_Test.Test_Group_Code = 'CH' 
	);
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter