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
To embed this project on your website, copy the following code and paste it into your website's HTML: