UPDATE 
  tbl_lab_setup_Test_Control 
SET 
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Days = '0', 
  ---DATE
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Hours = '2', 
  ---Hr
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Minutes = '0' ---Min
WHERE 
  tbl_lab_setup_Test_Control.Test_Code IN (
    SELECT 
      dbo.tbl_lab_setup_Test.Test_Code 
    FROM 
      dbo.tbl_lab_setup_Test 
    WHERE 
      dbo.tbl_lab_setup_Test.Test_Group_Code = 'CH' --- SECTIONฟ
      AND dbo.tbl_lab_setup_Test.Test_Order_Status_Flag = 1 
      AND dbo.tbl_lab_setup_Test.Test_Inactive = 0
  ) --SHOW DATA AFTER UPDATED
SELECT 
  dbo.tbl_lab_setup_Test.Test_Code, 
  dbo.tbl_lab_setup_Test.Test_Group_Code, 
  dbo.tbl_lab_setup_Test.Test_Name, 
  dbo.tbl_lab_setup_Test.Test_Order_Status_Flag, 
  dbo.tbl_lab_setup_Test.Test_Type_Code, 
  dbo.tbl_lab_setup_Test.Test_His_Code, 
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Days, 
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Hours, 
  dbo.tbl_lab_setup_Test_Control.Test_TAT_R_Minutes 
FROM 
  dbo.tbl_lab_setup_Test 
  INNER JOIN dbo.tbl_lab_setup_Test_Control ON dbo.tbl_lab_setup_Test.Test_Code = dbo.tbl_lab_setup_Test_Control.Test_Code 
WHERE 
  dbo.tbl_lab_setup_Test.Test_Group_Code = 'CH' --- SECTION
  AND dbo.tbl_lab_setup_Test.Test_Order_Status_Flag = 1 
  AND dbo.tbl_lab_setup_Test.Test_Inactive = 0 
ORDER BY 
  dbo.tbl_lab_setup_Test.Test_Seq ASC

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: