Re: date problem

tony wrote:
> Hi,
>
> I thought this would be a classic sort of query but google did no give
> me the answer.
>
> I am attempting to select records where one of the dates is the latest
> date before today
>
> select max(date) from expo where date < now()
>
> 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
)

--
Richard Huxton
Archonet Ltd