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
