update使用子查询和

1， 根据关联子查询，更新字段

 

1

2

3

4

5

Update tab1 t

Set (val1, val2) = (select val1, val2

from tab2

where workdate = t.workdate

and cino = t.cino);

 

2， 通过非关联子查询，限定更新范围

1

2

3

Update tab1 t

set val1 = 1

where (workdate, cino) in (select workdate, cino from tab2)