mysql三表关联分组带where
查不出来:
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' ...
原创
2013-09-07 18:18:38 ·
493 阅读 ·
0 评论