17,377
社区成员
发帖
与我相关
我的任务
分享
select ts.cycle_taskid,ts.task_content,sum(case when exists (select 1 from t_taskinfo t where t.cycle_taskid = ts.cycle_taskid) then 1 else 0 end )CreateNums,
sum(case when exists (select 1 from t_taskinfo t where t.cycle_taskid = ts.cycle_taskid and t.Finish_Time is not null) then 1 else 0 end )MadeNums
from T_TaskCycle_Setting ts