!!!DB2 別のテーブルの値で更新する
[DB2][Database]{{category SQL}}

{{amazon 4873113156}}

*サブクエリで複数列の値を同時に更新
*更新対象を抽出するためにset句とwhere句に相関サブクエリを使用 
 update employee_tmp tmp
 set (tmp.salary, tmp.bonus) 
     = (select emp.salary * 1.2, emp.bonus * 1.2 from employee emp
        where emp.empno = tmp.empno)  
 where 
     exists(select null from employee emp 
       where emp.empno = tmp.empno  
       and emp.workdept = 'A00')