截图的是我给参数添指定了表明设计器里面预览的时候,都能读到数据,预览就提示有一个列找不到,select * from (select a.dwh,a.jlmc 来源,a.hjcgmc 名称,a.hjrq 获奖日期, c.dwmc from ky_hjcgjbsj a left join ky_kjcgry b on a.id=b.sskjcgid left join xx_yxsdwjbsj c on a.dwh=c.dwh) zb where 1=1${if(dwh == "00000001" || len(dwh) == 0,""," and dwh = '" +dwh+ "'")} ${if(len(tbsj_ks) == 0,"","and HJRQ >= '" +tbsj_ks + "'")} ${if(len(tbsj_js) == 0,"","and HJRQ <= '" +tbsj_js + "'")}order by zb.dwh;