代码转换

  1.select p.longitude,       p.latitude,      p.Pollution_name,    p.monitor_level,     p.drainage_code,     (case monitor_level when '00' then '国控' when '01' then '省控' when '02' then '市控' end) monitor_level   from b_pollution_info p where 1=1

 2.与代码表关联