select  ' ºÏ¼Æ' XMMC00,'00' BH0000,
 sum(A.HJJE00) HJJE00 
 from  ZY_FYMX00 A ,BM_BMBM00 I 
   where  DECODE(A.KDBQ00,0,ZXKS00,A.KDBQ00)  = I.BMBH00  
   and  (I.YYID00='0' OR '0'='0')
   and  A.CZRQ00  >= '20180531'
   and  A.CZRQ00  <= '20180630'
   and  A.CZRQ00||A.CZSJ00 >= '2018053115:00:01'
   and  A.CZRQ00||A.CZSJ00 <= '2018063015:00:00'
 union  all  
 SELECT XMMC00,BH0000,HJJE00 FROM ( 
 select  C.XMMC00,C.BH0000,
 sum(A.HJJE00) HJJE00 
 from  ZY_FYMX00 A,BM_YYSFXM B,BM_FPXM00 C,BM_BMBM00 I
 where  A.XMBH00  = B.SFXMID  and  B.ZYFPID  = C.FPXMID  
   and  DECODE(A.KDBQ00,0,ZXKS00,A.KDBQ00)  = I.BMBH00  
   and  (I.YYID00='0' OR '0'='0')
   and  A.CZRQ00  >= '20180531'
   and  A.CZRQ00  <= '20180630'
   and  A.CZRQ00||A.CZSJ00 >= '2018053115:00:01'
   and  A.CZRQ00||A.CZSJ00 <= '2018063015:00:00'
 group  by  C.XMMC00,C.BH0000 order by C.BH0000)