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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
