in reply to Re^2: More MySQL woes
in thread More MySQL woes

Perhaps an alias can help you (not tested):
SELECT max(date) as m, ... WHERE date = m;

Replies are listed 'Best First'.
Re^4: More MySQL woes
by cosmicperl (Chaplain) on Jan 20, 2008 at 21:53 UTC
    I tried that as well... I finally found a solution below and it's certainly not an obvious one.
    Thanks for your help