select g.*,nvl((SELECT zje000 FROM vw_zs_basyxx_dzbl b WHERE b.lsh000 = g.zyid00),(select sum(c.hjje00) from zy_fymx00 c where c.zyid00=g.zyid00))
             zfy000  from VW_ZY_LJZRZC_ZYDZBL g where SJCYRQ>='20190823' and SJCYRQ<='20190826'   and DQKS00='37' order by JSFS00,JSYY00,LJMC00,CYRQ00,BRXM00