>;with cte as (SELECT Color.Title_E,Color2.Title_E AS Title_E2,Color,Color2 FROM RepairOrder > LEFT JOIN Color ON RepairOrder.NoColor=Color.Numero > LEFT JOIN Color AS Color2 ON RepairOrder.NoColor2=Color2.Numero) > >update cte set Color = Title_E, Color2 = Title_E2>