El vie, 29-08-2003 a las 22:05, Daniel Clark escribió: > > select value from tableName where date in (select max(date) from > > tableName where id = 4); > > > > But, it doesn't work with mysql 4.0. > > > > Any ideas? Does anybody had this problem before? > > What about: > > SELECT value, date > FROM tablename > WHERE id = 4 > ORDER BY date ASC > > Just pick the first row. > Thanks Daniel.
Yes, it's the last option. But, I think that there is a good one. I think that somebody had this problem before. Does anybody have more ideas? Thanks in advance and best regards boricles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]