<snip> > > 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 > > > > > > have a look here : > http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html > it should be useful for you. > Thanks Philippe that could do it.
Graham. > -- > Philippe Poelvoorde > COS Trading Ltd. > +44.(0)20.7376.2401 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
