Re: date problem

[Richard Huxton <dev@xxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster