>UPDATE r SET NoField = f.Numero > FROM Relation r >JOIN Field f ON r.Field = f.Field > >UPDATE r SET NoField2 = f.Numero > FROM Relation r >JOIN Field f ON r.Field2 = f.Field >Ok, thanks, but I need to apply more logic. So, I need to select the records at first and loop. What adjustment would I need to do to support that?