17,082
社区成员
发帖
与我相关
我的任务
分享
create table t1(f1 int, f2 int,f3 int);
create table t2(f1 int, f2 int,f3 int);
insert into t1 values(1,2,2);
insert into t1 values(2,3,3);
insert into t2 values(1,3,5);
insert into t2 values(3,4,6);
update t1 set (f2,f3)=(select f2,f3 from t2 where f1=t1.f1)
where exists(select 1 from t2 where f1=t1.f1);
select * from t1;
drop table t1;
drop table t2;
/*
F1 F2 F3
1 3 5
2 3 3
*/
update 表1 set 字段=b.字段 from 表1 a ,表2 b on a.字段=b.字段