select  0 as zflb00,ZFFS00,count(*) NUM,sum(NVL((JFJE00),0)) JE0000  from ZY_brjfb0  where  jflbid = 2 
 and ZFFS00 IN (1,2,3,4,10,11,8,18,24,25,28) and JFBZ00 in ('0','2') AND JFRQ00>='20201118'
 and  JFRQ00 <= '20201118'
 and  JFRQ00||JFSJ00 >= '2020111800:00:00'
 and  JFRQ00||JFSJ00 <= '2020111823:59:59'
  group by  ZFFS00
 union all 
select 1 as zflb00 ,ZFFS00,count(*) NUM,sum(NVL((JFJE00),0)) JE0000  from ZY_brjfb0  where  jflbid = 2 
 and  ZFFS00 IN (1,2,3,4,10,11,8,18,24,25,28) and JFBZ00 in ('1','3') AND  JFRQ00 >= '20201118'
 and  JFRQ00 <= '20201118'
 and  JFRQ00||JFSJ00 >= '2020111800:00:00'
 and  JFRQ00||JFSJ00 <= '2020111823:59:59'
  group by  ZFFS00