FROM should be after SET. Don't you know UPDATE syntax?
>>
>>
>>
>>
>>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.
--sb--