Update dbo.GuiaContacto Set id_franquicia= v.Id FROM dbo.GuiaContacto g INNER JOIN dbo.VS_guia2001 v ON g.franquicia = v.Enseña COLLATE SQL_Latin1_General_CP1_CI_AS