mysql三表关联分组带where_MySQL

来源：动视网责编：小采时间：2020-11-09 18:45:20

mysql三表关联分组带where_MySQL

mysql三表关联分组带where_MySQL:bitsCN.com mysql三表关联分组带where mysql 查不出来： 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

推荐度：

点击下载本文 文档为doc格式

导读mysql三表关联分组带where_MySQL:bitsCN.com mysql三表关联分组带where mysql 查不出来： 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

bitsCN.com

mysql三表关联分组带where

mysql

查不出来：

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

bitsCN.com

mysql三表关联分组带where_MySQL

推荐度：

点击下载本文 文档为doc格式

标签：关联 mysql 三表

热门焦点

mysql三表关联分组带where_MySQL

mysql三表关联分组带where_MySQL

mysql三表关联分组带where_MySQL

最新推荐

猜你喜欢

热门推荐