我对
MySQL查询相当新,尤其是更复杂的查询.
我有两个表要加入(x和y).表x包含Name,ID和TotalNum,其中y包含ID和Online.所以它看起来像这样:
表X
Name | Store| TotalNum
Blah | 1 | 3
Blah1 | 2 | 2 Etc..
表Y.
Store| Lane | Online
1 | 1 | 1
1 | 2 | 1
1 | 3 | 0
2 | 1 | 1
2 | 2 | 0
Etc..
我正在尝试将我的表连接在一起并返回Online = 1的计数
所以,我追求的结果是:
Name | TotalNum | Online
Blah | 3 | 2
Blah1 | 2 | 1
Etc..
到目前为止,我有以下查询:
SELECT s.Name, s.TotalNum, COUNT(r.Online = 1) AS Online FROM TableX AS r
LEFT JOIN TableY AS s ON s.Store = r.Store
WHERE r.Store = 'xx'
但它只返回总行数,无论Online = 1还是0.
任何帮助赞赏.谢谢