最后少了后面一个括号

=====

SELECT

  DISTINCT STATUS

FROM

  DM.CT_TRAIN_PLAN p

left join (select FID,MAX(TO_CHAR(CREATETIME,'yyyy-mm')) as TSDATE FROM CT_PLAN_TSRECORD GROUP BY FID) d on d.FID = p.FID

where 1=1

${if(len(pv1) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH >='" + pv1 + "'","and d.TSDATE >='" + pv1 + "'"))}

${if(len(pv1) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH <='" + pv8 + "'","and d.TSDATE <='" + pv8 + "'"))}

第二个不对吧

SELECT

  DISTINCT STATUS

FROM

  DM.CT_TRAIN_PLAN p

left join (select FID,MAX(TO_CHAR(CREATETIME,'yyyy-mm')) as TSDATE FROM CT_PLAN_TSRECORD GROUP BY FID) d on d.FID = p.FID

where 1=1

${if(len(pv1) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH >='" + pv1 + "'","and d.TSDATE >='" + pv1 + "'"))}

${if(len(pv8) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH <='" + pv8 + "'","and d.TSDATE <='" + pv8 + "'"))}