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.NumeroSo, basically, the first two fields contains the relational value from the color table. The Color and Color2 fields have been added in the RepairOrder table and they are Character(40). How can I use this SQL and turn it into an update to update the Color and Color2 fields with the relational value found in the first two fields?