看了一下代码，没看出哪里有问题SELECT distinct a2.cbat_code,a2.typ_name,a2.cas_date,a2.cbat_num,a2.cbat_mon,a2.time,case when a2.typ_name in ('渤海银行','中国银行','广发银行','光大银行' ,'招商银行', '中国邮政银行','渣打银行' ,'尚城消金' ,'兴业银行' , '新网银行','浦发银行','广州银行', '建设银行','中银消费','交通银行','农业银行','农商银行','中原银行','浦发零售贷') THEN '导出' END as gongnengFROM(SELECT distinct c.cbat_code,d.typ_name,a.cas_date,c.cbat_num,c.cbat_mon,b.hur_op_time as time,case d.typ_nameWHEN '渤海银行' THEN '曾益华'WHEN '中国银行' THEN '潘玉展'WHEN '广发银行' THEN '郑佳博'WHEN '光大银行' THEN '潘玉展'WHEN '招商银行' THEN '潘玉展'WHEN '中国邮政银行' THEN '岑金玲'WHEN '渣打银行' THEN '潘玉展'WHEN '尚城消金' THEN '岑金玲'WHEN '兴业银行' THEN '张家辉'WHEN '新网银行' THEN '潘玉展'WHEN '浦发银行' THEN '曾益华'WHEN '浦发零售贷' THEN '曾益华'WHEN '广州银行' THEN '岑金玲'WHEN '建设银行' THEN '潘玉展'WHEN '中银消费' THEN '潘玉展'WHEN '交通银行' THEN '黄旭辉'WHEN '农业银行' THEN '岑金玲'WHEN '农商银行' THEN '郑佳博'WHEN '中原银行' THEN '郑佳博'END as fuzeren,case WHEN d.typ_name in ('渤海银行','中国银行','广发银行','光大银行','招商银行','中国邮政银行','渣打银行','尚城消金','兴业银行','新网银行','浦发银行','广州银行', '建设银行','中银消费', '交通银行', '农业银行','农商银行','中原银行','浦发零售贷') THEN '梅逸莹' END as fuherenFROM bank_case ainner JOIN hurr_rec b ON a.cas_id = b.hur_cas_idINNER JOIN case_bat c ON a.cas_cbat_id = c.cbat_idINNER JOIN type_list d ON a.cas_typ_bid = d.typ_idWHERE b.hur_op_cont LIKE '%将案件催收区域修改为_YC%')a2WHERE 1=1${if(len(bank_set)=0,"","and a2.typ_name in ('"+SUBSTITUTE(bank_set,",","','")+"')")}${if(len(date_set)=0,"","and a2.cas_date in ('"+SUBSTITUTE(date_set,",","','")+"')")}
