按照多个计数和SUM()排序
问题我正在努力纠正下面的语法。我尝试过各种联合和连接,但都没有成功。我需要将这3个总数加起来作为“totcount”。这些数据的表非常大,我希望找到一种比用四个子查询更好的方法来获取总计数。 SELECT
location.*,data.status,
(SELECT COUNT(data.id) FROM data WHERE data.locid=location.locid AND data.status='NEW') AS newcount,
(SELECT COUNT(data.id) FROM data WHERE data.locid=location.locid AND data.status='IN-PROGRESS') AS ipcount,
(SELECT COUNT(data.id) FROM data WHERE data.locid=location.locid AND data.status='COMPLATED') AS compcount
FROM TP_l ...