Sorry, I forgot about that. Like I said, I didn't test it .

This will work, as I did test it:

Update Table1 Set phone2 = phone

	from Table1 inner join (Select Table2.keyvalue, min(addtlphone) phone

		from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue

		where addtlphone > phone1 group by Table2.keyvalue) T on Table1.keyvalue=T.keyvalue



Update Table1 Set phone3 = phone

	from Table1 inner join (Select Table2.keyvalue, min(addtlphone) phone

		from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue

		where addtlphone > phone2 group by Table2.keyvalue) T on Table1.keyvalue=T.keyvalue



...etc.

 

Jay Madren