Oracle双表关联条件更新

日常小记

UPDATE (select t1.function_location_id fl_id1,
               t1.tz_name            tzname1,
               t1.pt_date              ptdate1,
               t2.pk_id                 t2_id2,
               t2.tz_name            tzname2,
               t2.pt_date              ptdate2
          from tab01 t1, tab02 t2
         where t1.id = t2.id) t
   set t2_id2 = t2_id2, tzname1 = tzname2, ptdate1 = ptdate2;
commit;