update mm_fyinfo a set re2=(select b.pname from oy_district b where a.disid=b.id ) where a.re2='undefined'
update zl_fyinfo a set re2=(select b.pname from oy_district b where a.disid=b.id ) where a.re2='undefined'
update zl_fyinfo a set re2=(select b.pname from oy_district b where a.disid=b.id ) where a.re2='undefined'