将一个表的某列值更新到另一个表中.sql

  update  [ShareInfo_All].[dbo].[Tb_PHCode] set UpdateName =c.CompanyName from

  (select CompanyName,code from [ShareInfo_All].dbo.Tb_CompanyInfo where client='bayer' )c

  where 

  c.code= [ShareInfo_All].[dbo].[Tb_PHCode].code