select *,*,c.spbh,c.spmch,d.danwbh,d.dwmch,e.baozhiqi from jxddhz as a,jxddmx as b,spkfk as c,mchk as d,sphwph as e where a.rq between '2009-05-01' and '2009-05-18' and a.djbh=b.djbh and a.dwbh in(select dwbh from mchk where dwmch='重庆市巫峡医药有限责任公司') and b.spid=c.spid and d.dwbh=a.dwbh and e.spid=c.spid 我这里查出来有相同的记录,我想去除重复记录!但每个表里是没有重复记录的,但多表查询后返回的数据集是重复的,该怎么去除 呢
首先声明下:distinct是不能起作用的!
首先声明下:distinct是不能起作用的!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货