【Update的问题 谢谢 顺祝大家新春快乐！】

[flowerrain005]

两个表 t1和t2 t1的列 code和tname code这列全为空
t2的列 code和tname

我要让当t1的tname等于t2的tname的时候 就把t1的code更新为t2的code 如何实现？

[zarge]

update t1
set code = t2.code
from t1, t2
where t1.tname = t2.tname

[flowerrain005]

Anbody in ?

[flowerrain005]

Really so simple ?

[631799]

sure.

[flowerrain005]

3q

[jinjazz]

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.a

select * from t1
select * from t2
drop table t1
drop table t2

[flowerrain005]

3q

[vinsonshen]

update a set a.code = b.code from t1 as a, t2 as b where a.tname = b.tname

[flowerrain005]

3q