create view VW_PEIS_RSJE00_HIS
as
select count(distinct a.TJH000) RS0000,sum((TSJE00+ZFJE00)*a.CZBZ00) JE0000,a.CZRQ00,0 TJXZ00 from SY_PE_YWSJ_FKSHLS a, SY_PE_YWSJ_TJYW00 b
where a.SFYWID=b.SFYWID and b.TTID00=0
group by a.CZRQ00
union
select count(distinct a.TJH000) RS0000,sum((TSJE00+ZFJE00)*a.CZBZ00) JE0000,a.CZRQ00,1 TJXZ00 from SY_PE_YWSJ_FKSHLS a, SY_PE_YWSJ_TJYW00 b
where a.SFYWID=b.SFYWID and b.TTID00>0
group by a.CZRQ00