SELECTcount(*)as caseTotal,IFNULL(sum(t.State=13),0)as finishTotal, IFNULL(sum(t.State=6),0)as noHandleTotal, r.roadName,r.regionId,g.name
FROM cc_patrol c
leftjoin geocoding_road r on c.Section
案件表:区域表:道路表:案件状态表:SELECT count(*) as caseTotal,IFNULL(sum(t.State=13),0) as finishTotal, IFNULL(sum(t.State=6),0) as noHandleTotal, r.roadName,r.regionId,g.nameFROM cc_patrol c left join geocoding_road r on c.Section = r.idleft join geocoding_re