On Tue, 22 Feb 2005, Bruno Wolff III wrote:
> The standard way to do this is to use the max function and select the
> row that matches this value.
>
> However the nonstandard DISTINCT ON construct is a better way to go if
> you don't need to be portable.
>
Thanks Bruno... I'd like to combine this all into one single query, if
that's possible.
/j-p.