for ACCESS 数据库:
update a, b set a.name=b.name1 where a.id=b.id
for SQL Server 数据库:
update a set a.name=b.name1 from a,b where a.id=b.id
文章来源:https://www.cnblogs.com/jaysen/p/4832629.html
不要看他人高新,且看闲时谁在拼
for ACCESS 数据库:
update a, b set a.name=b.name1 where a.id=b.id
for SQL Server 数据库:
update a set a.name=b.name1 from a,b where a.id=b.id
文章来源:https://www.cnblogs.com/jaysen/p/4832629.html
不要看他人高新,且看闲时谁在拼
转载于:https://www.cnblogs.com/BoKeYuan259/p/10789162.html