SELECT fc.input_userid, fc.input_username,case when sum(fc.fc_num) >=0 then sum(fc.fc_num) else 0 end fc_NUM ,fc.cj_code ,fc.fcfee_TYPE ,fc.type
FROM EXTZZ.CW_CJYJFC fc , ld_ce_cjinfo ht
where fc.cj_code = ht.cj_code andht.ifdeleted =0 and fc.FC_DATE >= to_date('2018-01-01','yyyy-mm-dd HH24:MI') and fc.FC_DATE <= to_date('2018-03-31','yyyy-mm-ddHH24:MI') and fc.type ='联动合同'
group by fc.input_userid, fc.input_username,fc.cj_code ,fc.fcfee_TYPE ,fc.type ,to_char(fc.FC_DATE,'yyyy-mm')