Diane,

update test1 set c = (select c from test2 where test2.a=test1.a)

Results in a Function name is missing !

Guillaume