select c.zyh000,c.xm0000,(select bmmc00 from bm_bmbm00 where bmbh00=c.dqks00) ks0000,a.ljmc00,d.zdmc00,       
   (select to_char(wmsys.wm_concat(icdmc0)) from LJ_MBJRTJ where ljid00=a.ljid00) ljbhmc  from LJ_ZRZC00 a,(       
   select max(zrzcid) zrzcid from LJ_ZRZC00 where jsfs00='完成' group by zyid00) b,       
   zy_brxxb0 c ,bq_brzdxx d        
   where        
   a.zrzcid=b.zrzcid and a.zyid00=c.zyid00 and c.zyid00=d.zyid00        
   and d.zdlb00='3'  and c.sjcyrq between :开始日期 and :结束日期   
   and c.dqks00 =:科室      
   and   not exists  (select 1 from LJ_MBJRTJ where ljid00=a.ljid00 and d.zdmc00=icdmc0 )