* Boris Villazon
> 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
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
> FR
> 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.
