和主表一样选择

但需要加上个从表的条件控制,免的输出结果会重复

select KS_Article.ID,KS_Article.Tid,KS_Article.Title,KS_Article.Adddate,KS_Article.Intro,KS_User.Email,KS_User.QQ,KS_User.UserID,KS_User.UserName from KS_Article,KS_User where ks_article.articleinput=ks_user.username order by KS_Article.ID desc