Subject Re: [Firebird-Architect] Select most recent...
Author Daniel Achermann
Hi Jonathan

>What I'm trying to acheive is simply this: I want to select the most
>recent record in FICHESCORPS where PRODUIT has a certain specified
>value, based on a date field in a linked table called FICHES.
I solve this problem with the following statement:

SELECT FIRST 1 .... FROM Table ORDER BY Date, ...