琢磨了一天终于解决了,和大家分享
select top 10 C.ChannelID,C.InfoID,C.AnounName,C.Content,C.AddDate,A.ID,A.Tid,A.intro,A.Author,A.Title,A.Fname,L.FolderName,L.ID,L.Folder from (KS_Article A inner join KS_Comment C on A.ID=C.InfoID)inner join KS_Class L on A.Tid=L.ID where C.verific=1 and C.ChannelID=1 order by C.adddate desc
[loop=10]
<li>
<a href="{$Field(Tid,GetClassUrl,1,1)}"><h2>{$Field(FolderName,Text,0,...,0,)}</h2></a>
<div class="mainItem">
<div>
<h3>{$Field(Title,Text,40,...,0,)} <span style="font-size:12px; color:#CCC">{$Field(Author,Text,0,...,0,)} / 文</span>
</h3>
<p>{$Field(intro,Text,200,...,0,)}<a href="/html/{$Field(Folder,Text,0,...,0,)}{$Field(Fname,Text,0,...,0,)}"> [阅读全文]</a></p>
</div>
<div>
<p id="commit"><span>[评论]:</span>
<a href="#">{$Field(AnounName,Text,0,...,0,)}</a>{$Field(Content,Text,0,...,0,)}</p>
</div>
</div>
</li>
[/loop]