i have 2 tables in mysql database called following news , views. news contain information news views contain information view , newsid. want retrieve news number of views connected it. here i've tried far, seem return 1 row.
select n.id, n.title, n.image_url, n.date, count(v.news_id) news n join views v on v.news_id = n.id
aggregate function
without group by
returns 1 row, need add group by
clause
select n.id, n.title, n.image_url, n.date, count(v.news_id) news n join views v on v.news_id = n.id group n.id
Comments
Post a Comment