试试这样

select top 10 InfoID,ClassID,ChannelID,Title,AddDate,CopyFrom,Author from [KS_InfoList] Where CopyFrom =(select top 1 copyfrom from ks_infolist where infoid=[KS:Current:InfoID])