update a
set a.col = b.col
from b

------解决方案--------------------
两表通过什么关联？

update a set a.name=b.name from b where a.id=b.id

------解决方案--------------------
探讨


SQL code
update a
set a.col = b.col
from b



???