>does SELECT support a parameter that would allow the selection of the single oldest record in the table? Something like
>
>select min(datetimefield) from mytable
>
>but retrieving all the fields?
>
>Thanks
SELECT MyTable.*;
FROM MyTable;
INNER JOIN (SELECT MIN(datetimefield) AS DtField FROM MyTable) Tbl1;
ON MyTable.datetimefield = Tbl1.DtField
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.