title: error while counting a column and inner join another table
body: <p>i'm trying to count the most commented news. I have two tables: comments and news containing the same column: News_ID. here's the query</p>
  
  <pre><code>select *,count(News_ID) as count from comments inner join news where comments.News_ID = news.News_ID group by comments.News_ID order by count DESC limit 4
  </code></pre>
  
  <p>I get this error</p>
  
  <pre><code>#1052 - Column 'News_ID' in field list is ambiguous
  </code></pre>
  
  <p>Does it mean the column I'm trying to count?</p>