如何有效自定义SQL查询某个专题的文章列表应该怎么写?

KS_Article.SpecialID是用逗号分隔的

select TOP {$Param(0)} KS_Article.Title,KS_Article.ID,KS_Article.SpecialID,KS_Class.ID,KS_Class.FolderName,KS_Special.SpecialName,KS_Special.SpecialID from KS_Article,KS_Class,KS_Special where KS_Class.ID=cstr({$CurrClassID}) and KS_Special.SpecialName=(KS_Class.FolderName+"{$Param(1)}") and KS_Article.SpecialID=cstr(KS_Special.SpecialID)

这个只能取出KS_Article.SpecialID只有一项数值没豆号的

自己搞定，语句如下

select KS_Article.ID,KS_Article.Title,KS_Article.Adddate,KS_Photo.ID,KS_Photo.Title,KS_Photo.PhotoUrl,KS_Photo.Adddate,KS_SpecialR.ID,KS_SpecialR.InfoID,KS_SpecialR.SpecialID from ( KS_SpecialR inner join KS_Article on KS_SpecialR.InfoID=KS_Article.ID ) INNER JOIN KS_Photo ON KS_SpecialR.InfoID=KS_Photo.ID where KS_SpecialR.SpecialID={$CurrSpecialID} order by KS_SpecialR.ID

顶,我都想知道,希望高手出来帮忙.