[thelist] mysql: max in joins?

[Emma Jane Hogbin]

On Tue, Mar 04, 2003 at 04:37:14PM -0500, Beam wrote:
> how about "max(meta_comments.created)"?

D'uh! That'd do it, thanks. :) *rolls eyes at self* Any other comments on
whether or not I should put the last_comment_id into the articles table would
still be appreciated.

> also you might get a complaint about "id is ambiguous in GROUP BY clause" or
> something, so use "GROUP BY meta_articles.id"

I just changed the select statement so that it's meta_articles.id as id.

thanks y'all :)

emma

--
Emma Jane Hogbin
[[ 416 417 2868 ][ www.xtrinsic.com ]]