how to update table B flag which is null and there is a master table which has the values of flag with Table a

Created Sep 12, 2022 Edited Sep 12, 2022 Follow

UPDATE TEST_2 set b.flag = a.flag
FROM TEST_2 a INNER JOIN TEST_1 b ON a.id = b.id