今天终于研究出来调用会员的头像。

select top 100 C.ChannelID,C.InfoID,C.AnounName,C.Content,C.AddDate,A.ID,A.Tid,A.Title,A.Fname,U.UserName,U.UserFace from (KS_Article A inner join KS_Comment C on A.ID=C.InfoID)inner join KS_User U on C.AnounName=U.UserName where C.verific=1 and C.ChannelID=1 order by C.adddate desc

SELECT C.ChannelID, C.InfoID,C.verific, C.AnounName, a.ID, A.Tid, A.Title, U.UserName, U.UserFace, C.Content, C.AddDate FROM (KS_Article A INNER JOIN KS_Comment  C ON (A.ID = C.InfoID) ) LEFT JOIN KS_User U ON C.AnounName = U.UserName where C.verific=1 and C.ChannelID=1  ORDER BY C.AddDate DESC

终于成功了， 希望对大家有用，首页调用最新评论，并且判断是不是会员，如果是会员就输出会员头像。