logo
Toggle navigation
Begin main navigation
About
Projects
Download
Documentation
Wiki
Forums
Log In
Go!
OpenACS – The Toolkit for Online Communities
:
Forums
:
OpenACS Q&A
:
Need some help on a query!
: One Message
Begin main content
Forum OpenACS Q&A: Response to Need some help on a query!
Search:
Back to OpenACS Q&A
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.
Back to OpenACS Q&A