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' );