上面的语句没有问题,不过不要用ks_article.*,最好只查询出要用到的字段

select top 10 KS_Article.*,KS_User.UserFace,KS_User.UserName from KS_Article inner join KS_User on KS_Article.Inputer=KS_User.UserName where tid='20095429054635' order by id desc