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.

JJ Harrison

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

Reply via email to