Re: date problem

Le lundi 16 mai 2005 à 09:44 +0100, Richard Huxton a écrit :

> > works for one record but other fields I need must be in aggregate or
> > grouped. Is there a simple SQL request to get the most recent records
> > from a set of joined tables?
>
> SELECT * FROM expo WHERE date = (SELECT max(date) FROM expo WHERE date <
> now());
>
> In fact, you might want to rewrite the subselect. Oh, and "date" is
> likely to cause trouble as a column-name.
>
> SELECT * FROM expo
> WHERE my_date = (
>     SELECT my_date FROM expo
>     WHERE my_date < now()
>     ORDER BY my_date DESC LIMIT 1
> )

Thanks! I wasn't really using date but for clarity had put that instead
of my French column name...

Tony