select A.BRBLH0, GHID00,'' ,A.BRID00,A.XM0000,A.XB0000,A.YBKH00 ,MIN(A.SHJG00) AS SHJG00 ,SUM(A.HJJE00) AS HJJE00 ,SUM(A.ZFJE00) AS ZFJE00 ,SUM(A.JZJE00) AS JZJE00 ,A.BRFB00,A.YBLB00,A.YBMC00 ,YBBRLB,BRLBMC,TSBZMC from vw_yb_mzidfy A Where BRFB00= 3 and CZRQ00>='20131024' and CZRQ00<='20131024' and exists(select 1 from ic_ybbrlb where yblb00=a.yblb00 and ybzxlb='1') and YBLB00='-' --此处有误 and instr(','||'d,Z,o,c,@,Y,J,0,1,2,3,4,9,5,t,a,z'||',',','||yblb00||',')>0 group by BRBLH0,GHID00,BRID00,XM0000,XB0000,YBKH00,YBKH00,BRFB00,YBLB00,YBMC00,YBBRLB,BRLBMC,TSBZMC ----分中心选到省医保 YBLB00传入值'-' 正确的应为'1'