两个表之间的数据更新

update patient set add_uname=b.uname
from patient as a,uuser as b
where a.id=b.id

( 其中:a.id=b.id 是两表的关联条件)