select A.*,B.XM0000 as BRXM00,B.GHH000,B.YBGHH0,C.BMMC00 as GHKSMC,bb.YBKH00,bb.YBID00,e.ybmc00 
 from SF_JZB000 A ,SF_BRXXB0 B,BM_BRXXB0 BB, BM_BMBM00 C,IC_YBBRLB E 
 where A.BRID00=B.BRID00 and b.brid00=bb.brid00  and  bb.YBLB00 =  E.YBLB00 
 and  bb.FBBH00 =  E.FBBH00 AND A.MZID00=B.GHID00 AND b.GHKS00 = C.BMBH00  and  A.JZRQ00>='20140929' and  A.JZRQ00<='20140929' 
 and  A.JZRQ00|| A.JZSJ00>='2014092900:00:01' and  A.JZRQ00|| A.JZSJ00<='2014092923:59:59'
 and  A.YBDJH0<>'0' and  A.FBBH00=3 and  A.CXJZDH=0 
 and e.ybmc00='省医保中心'
order by  A.jzdh00