Update table1 t1,table2 t2
set t1.field2 = t2.field2
where t1.t2id = t2.id
[and t1.field3<999]
ACCESS 联表更新字段
最新推荐文章于 2021-08-21 08:46:23 发布
Update table1 t1,table2 t2
set t1.field2 = t2.field2
where t1.t2id = t2.id
[and t1.field3<999]