update [Test].[dbo].[Table_2] set ffff=a.name from [Test].[dbo].[Table_1] a,[Test].[dbo].[Table_2] b where a.uid=b.uid 希望能帮助到你！
update 表2 set ffff=‘你需要修改的内容’ where uid in（select uid from 表1 where name=aaa）
