select bb.ENFORCEUNIT,count(bb.pid) as num ,sum(bb.totalWeightGoods) as totalWeightGoods ,sum(bb.aftertotalMass) as aftertotalMass

from  bwsn_basicinfo bb

left join s_project sp on bb.pid =sp.id

left join s_unit su on bb.enforceUnitId =su.id

where (sp.status !='撤销' or sp.status is null) and caseType='联合治超'  

and  su.CATALOGROUTE like '%${pid}%'

and 时间字段 between '${dateStart_c}' and '${dateEnd_c}'

GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT 

HAVING sum(bb.totalWeightGoods)>='${textEditor0_c}'

sql的字符串要用单引号，不能用双引号，还有一个时间字段帮你加了进来，改成你的实际字段名就好了