update B set MoneyType = a.MoneyType , Info = a.Info
from B b
from B b
join A a on a.Id = b.Id
sql server多表关联update
UPDATE Tab1 SET a.Name = b.Name FROM Tab1 a,Tab2 b WHERE a.ID = b.ID