嵌套循环的update子查询语句

<span style="font-size:18px;">update b
   set b.object_name = (select a.object_name
                          from a
                         where a.object_id = b.object_id);<span style="font-size:18px;">update b
   set b