SQL语句执行卡死，在线等。

SQL语句执行卡死，
select a.CType as '类别',a.ChargeDetailsName as '费用名称',a.CDPayServiceName as '收费项目',
sum(a.ChargeDetailsPrice) as '费用总价',a.CDExecutiveSectionName as '执行科室',
a.CDOpenBillName as '开单科室',a.CDTime as '记账时间',a.CDHopitalName as '医院名称',
b.StaffName as '开单医生',c.CFRemarks as '费用类别'
from HJY_ChargeDetailsInfo as a LEFT JOIN HJY_StaffInfo as b on a.SID =b.SID
left join HJY_ChargeClassificationInfo as c on a.CDPayServiceName = c.ChargeClassificationName
--where
--a.ChargeDetailsName like '%粪便%'
--a.CType like '%门诊%'
group by a.CType,a.ChargeDetailsName,a.ChargeDetailsPrice,a.CDDepartment,a.CDTime,a.CDOpenBillName,a.CDHopitalName,
a.CDExecutiveSectionName,a.CDPayServiceName,b.StaffName,c.CFRemarks

你在后面为啥要加group by？你又不做统计，这样试试
select distinct a.CType as '类别',a.ChargeDetailsName as '费用名称',a.CDPayServiceName as '收费项目',
sum(a.ChargeDetailsPrice) as '费用总价',a.CDExecutiveSectionName as '执行科室',
a.CDOpenBillName as '开单科室',a.CDTime as '记账时间',a.CDHopitalName as '医院名称',
b.StaffName as '开单医生',c.CFRemarks as '费用类别'
from HJY_ChargeDetailsInfo as a LEFT JOIN HJY_StaffInfo as b on a.SID =b.SID
left join HJY_ChargeClassificationInfo as c on a.CDPayServiceName = c.ChargeClassificationName
--where
--a.ChargeDetailsName like '%粪便%'
--a.CType like '%门诊%'

你的group by 后面跟的条件太多，有点冗余了，你看下group by 后面有没有不必要的分组条件，可以去掉

连接查询的时候，建议把b表放在最前面，a表放中间，c表放最后面