!! Help with query: Where Date = MAX(Date)

[Graham Cossey]

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]