试一下这两个语句:甲:select top 10 b.ResourceID,b.nodeid from a,c,b ,KeywordView d where a.ResourceID=b.ResourceID and b.NodeID=c.NodeID and a.resourceid=d.resourceid and (c.NodeID=102 or c.NodePath like '0>1>%') and a.MediumID in(10,1,7,8) and b.DeleteFlag='V' and d.AllKeyword like '%中国%' order by a.Title Asc乙:select b.ResourceID,b.nodeid from a,c,b ,KeywordView d where a.ResourceID=b.ResourceID and b.NodeID=c.NodeID and a.resourceid=d.resourceid and (c.NodeID=102 or c.NodePath like '0>1>%') and a.MediumID in(10,1,7,8) and b.DeleteFlag='V' and d.AllKeyword like '%中国%' order by a.Title Asc
and d.AllKeyword like '%中国%'
order by a.Title Asc乙:select b.ResourceID,b.nodeid from a,c,b ,KeywordView d where a.ResourceID=b.ResourceID and b.NodeID=c.NodeID and a.resourceid=d.resourceid and (c.NodeID=102 or c.NodePath like '0>1>%') and a.MediumID in(10,1,7,8) and b.DeleteFlag='V'
and d.AllKeyword like '%中国%'
order by a.Title Asc