update a set a.A='哈哈' from [one] a Join [Two] b on a.A=b.A
1、update [ONE] set A='哈哈' where A in (select A from [TWO]) 2、update [ONE] set A='哈哈' from [ONE] where exists( select 1 from [TWO] where A=[ONE].A ) 3、update [ONE] set A='哈哈' from [ONE],[TWO] where [ONE].A = [TWO].A 4、update [ONE] set A='哈哈' from [ONE] inner join [TWO] on [ONE].A=[TWO].A
from [one] a Join
[Two] b on a.A=b.A
2、update [ONE] set A='哈哈' from [ONE] where exists( select 1 from [TWO] where A=[ONE].A )
3、update [ONE] set A='哈哈' from [ONE],[TWO] where [ONE].A = [TWO].A
4、update [ONE] set A='哈哈' from [ONE] inner join [TWO] on [ONE].A=[TWO].A