联合查询语句

例如：C#类型下的所有文章，文章1有五条评论， 文章2有三条评论， 文章3有一条评论， 文章4零条评论。

类型表
TypeId TypeName

typeAndArticle表
Id TypleId ArticleId

artilce表
ArticleId Title Content

comment表
CommentId ArticleId
SELECT A.TYPENAME,B.ARTICLEID,C.TITLE,C.CONTENT,COUNT(D.COMMENTID) COMMENTS
FROM 类型表 A,typeAndArticle B,artilce C,comment D
WHERE A.TYPEID = B.TYPEID AND B.ARTICLEID = C.ARTICLEID AND C.ARTICLEID = D.ARTICLEID AND A.TYPENAME = ‘C#’
GROUP BY A.TYPENAME,B.ARTICLEID,C.TITLE,C.CONTENT
ORDER BY COUNT(D.COMMENTID) DESC