Re: Help needed on a small SELECT/JOIN statement

[Chris Farrugia]

I will be adding a table called comments with the following fields:

number - primary key, autonumber
author
id - same as authors.id
type - either article, news, etc.

So with that, I was thinking I could modify the above SQL in the following way:

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