select  B.BMMC00,aa.BRZJLX,aa.BRZJBH,aa.XZQH00,A.*  from  zy_brxxb0 A,bm_brxxb0 aa,BM_BMBM00 B,IC_YBBRLB C where 
 a.brid00=aa.brid00 and A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND  cyrq00 is null  
 and  BMMC00  like  '儿科病区%'
  order  by  RYCWH0