MySQL count statement

Question

I am using this statement to count the numbers of occurrences of a particular ID

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

However in another table I have the title name for each of the cms_id

cms_id cms_name   
1     wordpress

How can I then retrieve the name form the other table and show this instead of the cms_ID

John Woo · Accepted Answer · 2013-05-07 02:46:47Z

2

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

To further gain more knowledge about joins, kindly visit the link below:

Visual Representation of SQL Joins

answered May 7, 2013 at 2:46

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL count statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related