这个怎么做参数吧这个db5b833fc3f6a90f1a0ac008a03ff713换成pid 传入

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 CONCAT("%","db5b833fc3f6a90f1a0ac008a03ff713","%")

GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT

FineReport sw0414 发布于 2021-4-29 17:18 （编辑于 2021-4-29 17:18）

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

axingLv6专家互助
发布于2021-4-29 17:25

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}%'

GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT

入海Lv6见习互助
发布于2021-4-29 17:27

and su.CATALOGROUTE like CONCAT("%","${pid}","%") 这样？

3关注人数

319浏览人数

最后回答于：2021-4-29 17:27

活动推荐更多

热门课程更多

确定取消