SELECT B.`序号`,B.`充电桩ID+`,SUM(IFNULL(A.`充电电量`,0)),SUM(IFNULL(A.`充电电费`,0)),COUNT(A.`序号`),SUM(IFNULL(A.`充电服务费`,0))
FROM `交易记录表` AS A,`桩信息表(跑数据用)` AS B
WHERE A.`充电桩ID`=B.`充电桩ID+`
GROUP BY B.`充电桩ID+`
ORDER BY B.`序号`查询的数据把空值删除了,想保留空值桩。该怎么改?
FROM `交易记录表` AS A,`桩信息表(跑数据用)` AS B
WHERE A.`充电桩ID`=B.`充电桩ID+`
GROUP BY B.`充电桩ID+`
ORDER BY B.`序号`查询的数据把空值删除了,想保留空值桩。该怎么改?
FROM `交易记录表` AS A,`桩信息表(跑数据用)` AS B
WHERE A.`充电桩ID`=B.`充电桩ID+`
GROUP BY B.`充电桩ID+`,B.`序号`
ORDER BY B.`序号`