大力 邹建 四脚蛇 快来！！

[zhuimeng313]

table1:

shbzh yhzh if_ssff
--------------------------
11111 451 是
22222 452 是

table2:

shbzh yhzh if_ssff
--------------------------
11111 null 是
22222 null 是

看看图 我想写个语句 按照shbzh 相对应 让下面的null 本别变成451 452
也就说
变成这样
table2:
shbzh yhzh if_ssff
--------------------------
11111 451 是
22222 452 是

[realgz]

update t2
set t2.yhzh=t1.yhzh,t2.if_ssff=t1.if_ssff
from table1 t1,table2 t2
where t2.shbzh=t1.shbzh

[dlpseeyou]

update t2
set t2.yhzh=t1.yhzh from t1 where t2.shbzh=t1.shbzh

[zjcxc]

update table2 set yhzh=(select shbzh from table1 where yhzh =a.yhzh)
from table2 a

[lvltt]

update table2
set yhzh=a.yhzh from table1 tem where tem.shbzh=table2.shbzh

[pengdali]

update table2 set yhzh=a.yhzh from table1 a where a.shbzh=table2.shbzh