[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
--
Emma Jane Hogbin
[[ 416 417 2868 ][ www.xtrinsic.com ]]
More information about the thelist
mailing list