通用栏目文章列表标签－如何显示栏目名字

select top 10 ID,Title,Adddate,Intro,Picurl,TitleFontType,Verific from KS_Article where verific=1 and tid in(select ID from KS_Class where (TS like '%20070400051480%' or TS like '%20071757912046%')) order by adddate desc

效果如图：
此主题相关图片如下：

循环体怎么写啊！！！　　［栏目名称］这个怎么就输出来了？

有人知道吗？等啊

select top 10 TID,ID,Title,Adddate,Intro,Picurl,TitleFontType,Verific from KS_Article where verific=1 and tid in(select ID from KS_Class where (TS like '%20070400051480%' or TS like '%20071757912046%')) order by adddate desc

通过字段tid可以得到