在线等 写条update语句，正确立即结贴

[xiaohu8855]

表t1
sno scost
1 15
2 24
表t2
sno cost
1 0
2 0

要求利用t1的scost 修t2的cost,在sno相等的情况下

[suiziguo]

通用的

update t2 set cost=(select scost from t1 where t1.sno=t2.sno)
where exists (select 1 from t1 where t1.sno=t2.sno);

[yaoweijq]

update t2
set t2.cost = (
select t1.scost
from t1
where t1.sno = t2.sno
)
供参考

[vanjayhsu]

[Quote=引用 1 楼 suiziguo 的回复:]
通用的

update t2 set cost=(select scost from t1 where t1.sno=t2.sno)
where exists (select 1 from t1 where t1.sno=t2.sno);
[/Quote]

好快啊。。。

[suiziguo]

SQL> select * from t1;

SNO SCOST
---------- ----------
1 15
2 24

SQL> select * from t2;

SNO COST
---------- ----------
1 0
2 0

SQL> update t2 set cost=(select scost from t1 where t1.sno=t2.sno)
2 where exists (select 1 from t1 where t1.sno=t2.sno);

已更新2行。

SQL> commit
2 ;

提交完成。

SQL> select * from t1;

SNO SCOST
---------- ----------
1 15
2 24

SQL> select * from t2;

SNO COST
---------- ----------
1 15
2 24

SQL>

[YY_MM_DD]

楼主都看那么一点点就好了

[xiaohu8855]

谢了啊

[leonbanana]

update t2 inner join t1 on t2.sno=t1.sno set t2.cost=t1.cost;