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