一、插入数据
create table code1 (code varchar(8),name varchar(16))
create table code2 (code varchar(8),name varchar(16))
insert into code2(CODE) values ('1')
insert into code2(CODE) values ('2')
insert into code1 values ('1','张三')
insert into code1 values ('2','李四')
二、更新
update code2 set name=code1.name from code1 where code1.code=code2.code
对于oracle
有两种方法:
1、sql更新
update code2 set name=(select name from code1 where code1.code=code2.code)
2、视图更新
update (select code1.name n1,code2.name n2 from code1 c1,code2 c2 where c1.code=c2.code) set n2=n1