如图1:以下是我的sql语句SELECT t1.ZJSL, t2.FYDSL, t2.YEAR, t2.MONTH, t2.DAY, TO_DATE(t2.YEAR || '-' || t2.MONTH || '-' || t2.DAY, 'YYYY-MM-DD') AS TIMEFROM t1LEFT JOIN t2 ON t1.YEAR = t2.YEAR AND t1.MONTH = t2.MONTHWHERE 1=1${if(len(start_time)=0,"","and T2.year || '-'|| T2.month||'-'||T2.day>='"+start_time+"'")}${if(len(end_time)=0,"","and T2.year || '-'|| T2.month||'-'||T2.day <='"+end_time+"'")}ORDER BY t2.YEAR, t2.MONTH更新后台查询数据如下: