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.与代码表关联
posted on
2011-07-07 09:39hl3292
阅读(173)
评论(0)
编辑收藏举报