去重复数据
select distinct substr(c.D_NUMBER,0,10) from DCZYDDXXB c ,pmdwxxb p ,ss_dept ss where substr(c.D_NUMBER,0,10)=p.DWBM and ss.deptid=p.dwbm and c.Ddrq>='20100513' and c.ddrq <='20100514'
中的数据为
6501030009
6501020015
6501020013
6501050005
6501030005
6501030013
6501020008
6501020011
6501050012
6501020007
6501020002
6501050003
6501020006
6501030007
select distinct substr(c.D_NUMBER,0,10) from FCDYDDXXB c ,pmdwxxb p ,ss_dept ss where substr(c.D_NUMBER,0,10)=p.DWBM and ss.deptid=p.dwbm and c.Ddrq>='20100513' and c.ddrq <='20100514'
6501020015
26501030006
36501040002
46501050004
56501030007
select distinct substr(c.D_NUMBER,0,10) from clzyddxxb c ,pmdwxxb p ,ss_dept ss where substr(c.D_NUMBER,0,10)=p.DWBM and ss.deptid=p.dwbm and c.Ddrq>='20100513' and c.ddrq <='20100514'
16501050005
26501030005
把这三张表的数据去除重复的
[解决办法]
这三条语句中间加一个union 就好了