我在bass的java代码里面写了这样的SQL语句:
select isnull(sum(a.fPostNum),0) as fPostNum,isnull(sum(a.fPostFinish),0) as fPostFinish,isnull(isnull(sum(a.fPostNum),0)-isnull(sum(a.fPostFinish),0),0) as fSynum from CR_PosterDeploy a where a.fUserID like '%1E9BE5FE038A4C349628D26E829F8847%' and (a.fPostNum-a.fPostFinish)>0 and getdate()<=a.fEndTime and getdate()>=a.fStartTime
可是在执行的时候提示错误,但是我在SQL查询分析器里面查看能查询出结果,并没有语法错误,请问这是什么原因。