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