这是报错
这是sql语句
SELECT my.template_id,template_name,pagefilename,display_mode,
xmlfilename,SUBJECT_NAME,my.remark,OPT1,COUNT(ts.SUBJECT_ID) subject_count,
case when template_type='fee' then '借款或申请'
when template_type='expense' then '报销或付款'
when template_type='bgt' then '预算申请'
when template_type='contract' then '合同模板'
else '其他'
end template_type_name,
template_type,
case when active_flag=1 then '启用' else '备用' end ACTIVE_FLAG,
case when (select COUNT(*) from S_FLOW_OPT WHERE OPT_TYPE=7 AND OPT2=my.TEMPLATE_ID)>0 THEN
(select FLOWBASE_NAME from s_FLOWBASE where FLOWBASE_NO= (select top 1 OPT1 from S_FLOW_OPT WHERE OPT_TYPE=7 AND OPT2=my.TEMPLATE_ID))
ELSE '未设置' END AS FLOW_FLAG
from S_TEMPLATE my
left join S_SUBJECT s on s.SUBJECT_ID=my.SUBJECT_ID
left join S_TEMPLATE_SUBJECT ts on ts.template_id=my.template_id
where my.template_name like '%%' and my.active_flag>0and my.TEMPLATE_TYPE like '%%' and my.hs_system_id like '%'
group by template_type,my.template_id,template_name,pagefilename,xmlfilename,SUBJECT_NAME,my.remark,OPT1,my.ACTIVE_FLAG,display_mode
order by OPT1 asc,template_name
这是结果集类型
这是实体类
希望大佬帮我看下这个怎么弄