1个update的小问题

SQL> select * from t1;

A              B
----- ----------
a            111
b            112
c            113
d            114
e            115
f            116

6 rows selected.

Elapsed: 00:00:00.02
SQL> select * from t2;

A              B
----- ----------
a            211
b            212
c            213
d            214
e            215
f            216

6 rows selected.

Elapsed: 00:00:00.02
SQL>

update t1 set t1.b=(select t2.b from t2 where t1.a=t2.a)
     where t1.a in (select t2.a from t2);
    
  SQL> update t1 set t1.b=(select t2.b from t2 where t1.a=t2.a)
  2       where t1.a in (select t2.a from t2);

6 rows updated.

Elapsed: 00:00:00.02
SQL> select * from t1;

A              B
----- ----------
a            211
b            212
c            213
d            214
e            215
f            216

6 rows selected.

Elapsed: 00:00:00.01
SQL>