Hi Arno,

Arno Brinkman wrote:

>Hi Alexandre,
>
>Yes, you can read that Firebird will put the condition into the HAVING
>clause and thus be performed after the aggregation. Why the HAVING clause?
>Because you could use a aggregate-function from the VIEW and that cannot be
>translated to the WHERE clause and must be in the HAVING clause. This is 1
>of the optimalizations that need to be done in the optimizer.
>
>Regards,
>Arno Brinkman
>ABVisie
>

Understood !

Thank you Arno !

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br