create table t1(a integer,b integer)create table t2(a integer,b integer)insert into t1(a) values (1) insert into t1(a) values (2) insert into t1(a) values (3) insert into t1(a) values (4) insert into t2(a,b) values (1,5) insert into t2(a,b) values (2,5)update t1 set t1.b=t2.b from t2 where t1.a=t2.aselect * from t1 select * from t2 drop table t1 drop table t2
update a set a.code = b.code from t1 as a, t2 as b where a.tname = b.tname
insert into t1(a) values (2)
insert into t1(a) values (3)
insert into t1(a) values (4)
insert into t2(a,b) values (1,5)
insert into t2(a,b) values (2,5)update t1 set t1.b=t2.b from t2
where t1.a=t2.aselect * from t1
select * from t2
drop table t1
drop table t2