|Subject||Re: *** SPAM (5.7) *** Re: [firebird-support] sub select befor from statment|
> But isn't it rather complicated to achieve the "first 1" semantics inNot so complicated if you note that original subselects don't have
> the OP's way using joins?
ORDER BY clause.
> How would you suggest to do that? (Not that I can't see a solution, justUse aggregates. Because order is not set, MAX() will work not worse
> not a very neat one...)