On Fri, 2005-02-04 at 09:19, Graham Cossey wrote: > Could someone please offer a little help. > > I have a table like: > > Year, Month, Start_date > 2004 10 20041102 > 2004 11 20041203 > 2004 12 20050104 > 2005 01 20050204 > 2005 02 20050303 > > I need to get the latest Year,Month for a given date, so for example today > (20050204) I should retrieve 2005,01. > > As I'm using 4.0.20 I can't use subqueries so how can I create a query that > does this? > > SELECT year, month > FROM `dc_months` > WHERE start_date = (SELECT MAX(start_date) > from dc_months > where start_date <= '20050204') > > Any help much appreciated > > Graham
I think this conveys the idea: SELECT year, month FROM `dc_months` WHERE start_date <= '20050204' ORDER BY start_date DESC LIMIT 1 -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
