复杂的MS Access Greatest-N-Per-Group问题

复杂的MS Access Greatest-N-Per-Group问题

怎么样：

Select  scouting.astroLoc,         scouting.galaxy,         scouting.jumpGate,         scouting.ownerGuild From    galaxy Inner Join         scouting On galaxy.[galaxy_ID] = scouting.galaxy WHERe   (scouting.ID) In (  Select Top 3 scouting.ID  From scouting   Where scouting.galaxy = galaxy.[galaxy_ID]   And scouting.ownerGuild = 'SWARM'   Order By scouting.jumpGate Desc) Order By    scouting.astroLoc Desc,      scouting.jumpGate Desc

否则，似乎前三名可能会包含一些

  where scouting.ownerGuild <> 'SWARM'