表连接更新具体字段

update  a  set a.field ='FAILURE'
from tbl1 a inner join tbl2 b on a.pkid = b.fkid
where b.field2 >= '2021-10-10'