做数据分析和数据处理的时候之前一定要确定数据源是正确的;
update mp_area_tagt set (t.pk_area,t.area_name) =(select min(b.pk_area),b.areaname from mp_bd_area b where t.area_name=b.areaname and t.pk_lastarea=b.pk_lastareaand nvl(dr,0)=0 group by b.areaname)
做数据分析和数据处理的时候之前一定要确定数据源是正确的;
update mp_area_tagt set (t.pk_area,t.area_name) =(select min(b.pk_area),b.areaname from mp_bd_area b where t.area_name=b.areaname and t.pk_lastarea=b.pk_lastareaand nvl(dr,0)=0 group by b.areaname)