A quick (and hopefully easy) question.
We have two tables, one for storing atricles, and another for storing comments assciated with the article.
ID, picture, title, text
ID, articleID, comment
Now I want to be able to select the following;
article.title, article.text, article.picture, Count(select row countof comments associated with article) FROM article;