create table A ( id int, value varchar(10) );
create table B ( id int, orig_id int );

update A
set a.id = b.id
from A a inner join B b on a.id = b.orig_id