Tell the truth, you have all VFP source code in your head?

Man I have been in this forum for 6 years and I have learned a lot from your posts.

Thanks.

Luis

>Yes, I'm sure and you're correct too. :)
>In a regular query HAVING is applied after GROUP BY and before ORDER BY. In UNION query HAVING can only be applied to individual SELECTS not the final recordset. Only ORDER BY is applied to the final recordset.
>
>but in UNION query it's aplied to individual record sets not the final recordset produced by the query.
>
>>Are you sure about that, Sergey? I thought that HAVING was applied after almost all other criteria in the SELECT clause; that is, applied to the preliminary result set and that was the difference between HAVING and WHERE.
>>
>>>No, only ORDER BY clause is applied to the whole result set. The HAVING clause is applied to each query in UNION. You can use derived table to apply additional conditions