update
table
set
name
=b.
name
from
table
a,
(
select
name
from
table2
)b
where
a.
name
=b.
name
update
table
set
name
=b.
name
from
table
a,
(
select
name
from
table2
)b
where
a.
name
=b.
name