试下这句

select top 10 a.ID,a.CompanyName,a.ContactMan,a.Mobile,a.Intro,a.UserName,b.UserFace from KS_Enterprise a inner join KS_User b on a.username=b.username order by a.id desc