MySQL count语句

Question

我使用这条语句来计算特定ID出现的次数

SELECT cms_id, COUNT( * ) AS Number
FROM website
GROUP BY cms_id
ORDER BY  `website`.`cms_id` ASC 
LIMIT 0 , 30

但是，在另一个表中，我有每个cms_id的标题名称

cms_id cms_name   
1     wordpress

然后如何从另一个表中检索名称并显示该名称，而不是显示cms_ID

Answer 1

SELECT  a.cms_id, b.cms_name, COUNT(*) AS Number -- <<== you can remove a.cms_id
FROM    website a
        INNER JOIN anotherTable b
            ON a.cms_id = b.cms_id
GROUP   BY a.cms_id, b.cms_name
ORDER   BY a.cms_id ASC 
LIMIT   0 , 30

要进一步了解joins，请访问下面的链接：

• Visual Representation of SQL Joins