>>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".
--sb--