SQL语法
update 表1 set 字段1 = bb.字段1 from 表1 as aa,
(select 字段1,字段2 from 表) bb where aa.字段2 = bb.字段2
Access语法
update
表1 as a ,
表
2 as b set a.
字段1= b.
字段1 where a.StuNo=b.StuNo
转载于:https://www.cnblogs.com/dcrenl/p/4041141.html