求助,简化一个Select查询
一个文章分类表(Class),一个文章表(Article),
请问下面的这条语句,怎么样简化一下,(用JOIN关键字),为什么?先谢了
SELECT ClassID,
ClassName,
(SELECT TOP 1 Article.ArticleID FROM Article WHERE Article.IncludePic=1 AND Article.RootClassID=Class.ClassID ORDER BY Article.OnTop DESC,Article.Elite DESC) AS ArticleID,
(SELECT TOP 1 Article.Title FROM Article WHERE Article.IncludePic=1 AND Article.RootClassID=Class.ClassID ORDER BY Article.OnTop DESC,Article.Elite DESC) AS Title,
(SELECT TOP 1 Article.DefaultPicUrl FROM Article WHERE Article.IncludePic=1 AND Article.RootClassID=Class.ClassID ORDER BY Article.OnTop DESC,Article.Elite DESC) AS DefaultPicUrl
FROM Class
WHERE ClassGrade=0