>>>It's documented behavior of ORDER BY in UNION query in VFP9.
>>>
>>
>>where ?
>
>VFP9 help SELECT - SQL Command - ORDER BY Clause
>
>"If the ORDER BY clause is applied to a UNION operation, the alias should be a Select_Item in the last SELECT clause".

And this what it centers with the name of the fields of the result?

I hope that Aleksey he realizes where the error is
(it is in an array of names of the internal routine C++)

Do you think that it is correct that these two queries return two different results?

CREATE CURSOR AA (MM I)

SELECT 1.00 X1 FROM AA;
UNION ALL;
SELECT 1.00 FROM AA ORDER BY 1

SELECT 1.00 X1 FROM AA;
UNION ALL;
SELECT 1.00 Y1 FROM AA ORDER BY 1