提示：试试使用sql标签

相册表在ks_photoxc

荣誉证书ks_enterprisezs

如

select top 10 a.id,a.xcname,a.photourl from ks_photoxc a inner join ks_article b on a.username=b.inputer where b.id={$CurrInfoID} order by a.id desc