> --- In firebird-support@yahoogroups.com, "Alan McDonald" wrote:
> > > Hi Fabian!
> > >
> > > Don't ever use FIRST within a subselect, it simply does not work!
> >
> > it does work where order is not important. I use it sometimes with
> > no ill effect
> > Alan
>
> OK Alan, I stand corrected - and confused... Why would anyone want to
> use SELECT FIRST in a subselect without any ORDER BY??
>
> And I didn't mean it had ill effects (even with ORDER BY), just that
> it were ignored and could be omitted from the subselect.
>
> Set
>

in one instance (legacy database) I need a field value from a table where a
subselect is the only fast way to retrieve it and since there are other
records by this same Fkey but all records have the same value I am after. As
I say - not my data design but FB delivers for me.
Alan