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调用出来！

多谢各位帮忙！！！