表里面有1000多条数据，不能一条条的update哦update simple1 set name = (select name from simple2 where simple2.id = simple1.id); update simple1 a set a.name =(select b.name from simple2 b where a.id=b.id) update simple1 set name = (select name from simple2 where simple2.id = simple1.id); 1、2楼写的条件语句（如select b.name from simple2 b where a.id=b.id） 均报’a‘.’id‘标识符无效或者 'simple'.'id'标识符无效
SQL code:
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);
