select ID,Tid,Title,ArticleInput,Adddate,Hits,rank,Intro,Articlecontent,Verific,KS_Pic,(select username,userface from ks_user where username=KS_U_shipinzhongxin.ArticleInput) as userface from KS_U_shipinzhongxin order by id desc

我SQL语句不怎么样

KS_U_shipinzhongxin表里面的ArticleInput字段和KS_user 表里面的username相同，请帮忙把KS_user里面的userface调用出来！

多谢各位帮忙！！！

select top 6 KS_Enterprise.CompanyName,KS_Enterprise.Recommend,KS_Enterprise.UserName,KS_User.RegDate,KS_User.UserFace,KS_User.UserName,KS_User.UserType from KS_Enterprise,KS_User where KS_User.UserName= KS_Enterprise.UserName and KS_Enterprise.Recommend=1 order by KS_User.RegDate desc

和你的功能差不多

你参照一下 我为了显示推荐企业的logo 把企业信息表KS_Enterprise和KS_User联系起来

使用KS_User.UserName= KS_Enterprise.UserName 作为连接