17,377
社区成员
发帖
与我相关
我的任务
分享
create table simple1 (id number, name varchar2(20));
create table simple2 (id number, name varchar2(20));
insert into simple1 values (1, 'Tom');
insert into simple1 values (2, 'Jack');
insert into simple1 values (3, 'Andy');
insert into simple2 values (1, 'Amy');
insert into simple2 values (2, 'Mary');
insert into simple2 values (3, 'Cindy');
update simple1 set name = (select name from simple2 where simple2.id = simple1.id);