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

```
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

```

I get this error

```
#1052 - Column 'News_ID' in field list is ambiguous

```

Does it mean the column I'm trying to count?