MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Help needed on a small SELECT/JOIN statement
Posted by: Jay Pipes
Date: November 04, 2005 01:11PM

Because only one has been viewed. To remedy, use a LEFT JOIN:

SELECT a.id, a.title, a.summary, a.dateposted, COUNT(*) as num_views
FROM articles a
LEFT JOIN views v ON a.id = v.id
GROUP BY a.id
ORDER BY a.dateposted DESC
LIMIT 0,10

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Help needed on a small SELECT/JOIN statement
2527
Chris Farrugia
November 04, 2005 10:23AM
Re: Help needed on a small SELECT/JOIN statement
1648
Jay Pipes
November 04, 2005 11:52AM
Re: Help needed on a small SELECT/JOIN statement
1640
Chris Farrugia
November 04, 2005 12:02PM
Re: Help needed on a small SELECT/JOIN statement
1663
Jay Pipes
November 04, 2005 01:11PM
Re: Help needed on a small SELECT/JOIN statement
1654
Chris Farrugia
November 04, 2005 01:32PM
Re: Help needed on a small SELECT/JOIN statement
1622
Jay Pipes
November 04, 2005 03:12PM
Re: Help needed on a small SELECT/JOIN statement
1351
Chris Farrugia
November 04, 2005 03:19PM
Re: Help needed on a small SELECT/JOIN statement
1597
Chris Farrugia
November 04, 2005 12:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.