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