ksql报错问题

xjj2hll

执行ksql:select SUM(p.FCOSTAMT) totalAmount, p.FCOSTTYPENAME caotName, q.FOUTTYPE reimType, q.FLOANDEPTNAME deptName, q.FLOANDEPTID deptID from OA_FC_REIMBAPPLYD p inner join OA_FC_REIMBAPPLYM q on p.FREIMFID = q.FID where p.FREIMFID in (select a from OA_FC_REIMBAPPLYM a where a.FLOANDATE >= '2013-03-15' and a.FLOANDATE <= '2013-03-15' and a.FLOANDEPTNAME='平台部') group by p.FCOSTTYPENAME,q.FLOANDEPTNAME,q.FLOANDEPTID,q.FOUTTYPE时出错！

UM(p.FCOSTAMT) ^^totalAmount, p. 中未找到需要的token, 位置：23 需要下列之一：FROM

jishuang

如果是报表中的用sql就可以

xjj2hll

好了