|
由于业务需要,我需要写一个ksql,用到setFilter方法,但是系统会提示报错,看了下信息,好像说的是ksql不支持重复的表名和列名;
现在sql如下,哪位大神帮忙看一下, 这段sql转化为setFilter该怎么写
select *
from sa_task t
where t.sdata1 in (SELECT SA_Task.SData1
FROM SA_Task SA_Task
WHERE SA_Task.sStatusID = 'tesFinished'
and SA_Task.SkindID = 'tkProcessInstance'
AND add_months(sysdate, -3) < SA_Task.sLastModifyTime
AND SA_Task.sESField05 is null)
and t.Sactivity = 'businessActivity1'
and t.sexecutemode2 is null
|
|