select A.ZFFSMC, sum(JEHJ00) JEHJ00, sum(ZFJE00) ZFJE00, sum(YBZH00) YBZH00, sum(TCJE00) TCJE00, sum(POSJE0) POSJE0, ,sum(JEHJ0S) JEHJ0S, sum(ZFJE0S) ZFJE0S, sum(YBZH0S) YBZH0S, sum(TCJE0S) TCJE0S, sum(POSJES) POSJES from VW_PE_JZZFFX A, SY_PE_YWSJ_SFJZ00 B where A.JZID00 = B.JZID00 and B.JZZZRQ between ? and ? and B.JZY000 = ? and A.JEHJ00 <> 0 group by A.ZFFSMC