Oracle关联update

hhuxyb

1. create table t1(
   
2. id number,
   
3. name varchar2(10)
   
4. );
   
5. insert into t1 values(1,'a');
   
6. insert into t1 values(2,'b');
   
7. insert into t1 values(3,'c');
   
8. insert into t2 values(1,'','a1');
   
9. insert into t2 values(2,'','b2');
   
10. insert into t2 values(3,'','c3');

11. 现在t2表中的name字段要根据t1表中的name更新；

    update t2 set name=(select name from t1 where t1.id=t2.id) where   exists (

    select id from t1 where t2.id=t1.id);

    select * from t2

    id name loc

    1 a a1
    2 b b2
    3 c c3