update a set a.field ='FAILURE'
from tbl1 a inner join tbl2 b on a.pkid = b.fkid
where b.field2 >= '2021-10-10'
表连接更新具体字段
最新推荐文章于 2024-07-22 15:27:09 发布
update a set a.field ='FAILURE'
from tbl1 a inner join tbl2 b on a.pkid = b.fkid
where b.field2 >= '2021-10-10'