title: MYSQL group by and inner join
body: <p>I have an article table which holds the number of articles views for each day.  A new record is created to hold the count for each seperate day for each article.</p>
  
  <p>The query below gets the article id and total views for the top 5 viewed article id for all time :</p>
  
  <pre><code>SELECT article_id, 
  SUM(article_count) as cnt
  FROM article_views
  GROUP BY article_id
  ORDER BY cnt DESC
  LIMIT 5 
  </code></pre>
  
  <p>I also have a seperate article table which holds all the article fields.  I want to ammend the query above to join to the article table and get two fields for each article id.  I have tried to do this below but count is comming back incorrectly :</p>
  
  <pre><code>SELECT article_views.article_id, SUM( article_views.article_count ) AS cnt, articles.article_title, articles.artcile_url
  FROM article_views
  INNER JOIN articles ON articles.article_id = article_views.article_id
  GROUP BY article_views.article_id
  ORDER BY cnt DESC
  LIMIT 5
  </code></pre>
  
  <p>Im not sure exactly what im doing wrong.  Do I need to do a subquery?</p>