I have this query:
select avg(article_comment.vote) as avg, article_data.aid,
article_data.time, article_data.name, article_data.description from
article_data, article_comment where article_comment.aid = article_data.aid
AND released > 1 GROUP BY article_data.aid order by time desc
One table has article data. The other has article comments (which include a
With this query it only returns articles with comments. How can I get it to
return all of them? (and return 0 as avg if there are no comments)
I am really stuck here.
Please reply on the list/newsgroup unless the reply it OT.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php