>>

>>
>>--SELECT Color.Title_E,Color2.Title_E AS Title_E2,Color,Color2 FROM RepairOrder
>>
>>UPDATE RepairOrder FROM RepairOrder
>>    SET Color2  = Color2.Title_E , Color = Color.Title_E
>> LEFT JOIN Color ON RepairOrder.NoColor=Color.Numero
>> LEFT JOIN Color AS Color2 ON RepairOrder.NoColor2=Color2.Numero
>>

>>
>>BTW, why are you using char(40) instead of varchar(40) ?
>
>This seems like an interesting approach. I tried it and got: "Incorrect syntax near the keyword 'FROM'" however.
>
>I am using Char(40) presently just to be conform with what I already have. At one point, I will do a massive update on some structures and will take care of that.

Move FROM just before the LEFT JOIN. Or try CTE approach.

UPDATE RepairOrder 
    SET Color2  = Color2.Title_E , Color = Color.Title_E
FROM RepairOrder

 LEFT JOIN Color ON RepairOrder.NoColor=Color.Numero
 LEFT JOIN Color AS Color2 ON RepairOrder.NoColor2=Color2.Numero