>

>
>--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.