mysql三表关联分组带where

最新推荐文章于 2022-10-03 14:07:59 发布

zph999

最新推荐文章于 2022-10-03 14:07:59 发布

阅读量470

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/zph999/article/details/84477317

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

查不出来：
SELECT e.id,e.ename,COUNT(s.id) AS total FROM enterprise e LEFT JOIN comm_port p ON e.id = p.eid LEFT JOIN sendedoutbox s ON p.port = s.CommPort WHERE s.SendTime BETWEEN '2013-08-09 15:31:35' AND '2013-08-28 10:47:28' GROUP BY p.eid ORDER BY total DESC

正确能查出来：
SELECT e.id,e.ename,COUNT(s.id) AS total FROM enterprise e LEFT JOIN comm_port p ON e.id = p.eid LEFT JOIN (SELECT * FROM sendedoutbox s WHERE s.SendTime BETWEEN '2013-08-09 15:31:35' AND '2013-08-28 10:47:28') s ON p.port = s.CommPort GROUP BY p.eid ORDER BY total DESC