Forum OpenACS Q&A: Response to Need some help on a query!

Collapse
2: Response to Need some help on a query! (response to 1)
Posted by Jonathan Ellis on 05/04/01 05:27 PM
you need to select the whole row from where game_id is the max, 

select ...
from ...
where mo.game_id = (select max(game_id) from moves, ... where ...)
you shouldn't need the distinct, either.