update A
set
NAME
=
B.NAME from A join B on A.ID
=
b.ID
/**/ /*=============================================*/
update b
set newname = a.name
from b,a
where b.id = a.id
/**/ /*=============================================*/
update b
set newname = (select name from a where id = b.id)
/**/ /*=============================================*/
update b
set newname = a.name
from b,a
where b.id = a.id
/**/ /*=============================================*/
update b
set newname = (select name from a where id = b.id)