各位大神们，请问一下自定义SQL在首页如何调用所有专题文章，分别有表：KS_Article、KS_U_a、KS_U_b、KS_U_C，都有专题，如何在首页调出这些表的专题名称和文章名称及链接：【专题名】文章名。使用以下方法只能调用出一个表的文章，且不带有链接select KS_Article.ID,KS_Article.Tid,KS_Article.Title,KS_Article.Author,KS_Article.Origin,KS_Article.Adddate,KS_Article.Hits,KS_Article.Intro,KS_Article.KeyWords,KS_SpecialR.InfoID,KS_SpecialR.SpecialID,KS_Special.specialid,KS_Special.specialname,KS_Special.specialename,KS_Special.photourl,KS_Special.specialnote from KS_Article,KS_SpecialR,KS_Special where KS_Article.ID = KS_SpecialR.InfoID and KS_Specialr.specialid = KS_Special.specialid and ks_article.tid in ({$CurrClassChildID}) and KS_Article.verific=1 order by KS_Article.id desc

查询 KS_ItemInfo 表

请问下大神，该怎么写呢？我试了不行，或者是我没写对。

select KS_ItemInfo.ID,KS_ItemInfo.Tid,KS_ItemInfo.Title,KS_SpecialR.InfoID,KS_SpecialR.SpecialID,KS_Special.specialid,KS_Special.specialname,KS_Special.specialename,KS_Special.photourl,KS_Special.specialnote from KS_ItemInfo,KS_SpecialR,KS_Special where KS_ItemInfo.ID = KS_SpecialR.InfoID and KS_Specialr.specialid = KS_Special.specialid and KS_ItemInfo.tid in ({$CurrClassChildID}) and KS_ItemInfo.verific=1 order by KS_ItemInfo.id desc这样写无法获取到文章