I haven't tested this, but something along these lines should work:

Update Table1 Set phone1 = min(addtlphone)

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



Update Table1 Set phone2 = min(addtlphone)

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

	where addtlphone > phone1



Update Table1 Set phone3 = min(addtlphone)

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

	where addtlphone > phone2



...etc for the rest of them

 

Jay Madren