[thelist] mysql: max in joins?

Emma Jane Hogbin emmajane at xtrinsic.com
Tue Mar 4 16:35:00 CST 2003

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 Jane Hogbin
[[ 416 417 2868 ][ www.xtrinsic.com ]]

More information about the thelist mailing list