Hi Fabio,

I agree with David and Sergey. Why do we want to create inconsistent names to begin with and then try to blame VFP for not resolving it properly? Even if this is a bug, it's a bug that was provoked on purpose.

>>Fabio,
>>
>>>Because you are alone that you say that this is not a bug,
>>>I always have trust that somebody else understands that this is a bug,
>>>because the names of the fields of the result are not deterministic.
>>
>>Most developers that want specific column names in their final result specify them in the query. So count me in as another one that doesn't think this is a bug in VFP.
>
>I think that you have not understood where the problem is.
>
>Are you happy that these two queries return a final cursor with different column name?
>
>

>* this return X
>SELECT F1 X FROM T1;
>UNION ALL;
>SELECT F2 Y FROM T2
>
>* this return Y
>SELECT F1 X FROM T1;
>UNION ;
>SELECT F2 Y FROM T2
>