用sql标签,需要查询ks_article表和ks_enterprise表

差不多这样吧

select top 10 b.companyname,b.username,a.id,a.title from ks_article a inner join ks_enterprise b on a.articleinput=b.username where a.verific=1 order by a.id desc