多表关联的视图产生重复行的原因 ----笛卡尔积
摘要:今天处理两个报障都是关于视图优化的问题在视图中看到重复行很多视图语句如下 select left(b.code_record,10) as DJLSH,(CASE d.yl_code WHEN 'QT' then (d.yl_code+'-'+left(a.ybh,2)) else d.yl...
阅读全文
posted @ 2015-10-14 17:43
posted @ 2015-10-14 17:43
posted @ 2015-10-05 19:53
posted @ 2015-10-03 15:50
posted @ 2015-10-02 17:52
posted @ 2015-10-01 22:56