--- 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