It's documented behavior of ORDER BY in UNION query in VFP9.

>when VFP apply a ORDER pass ( it do this also to make the distinct pass )
>VFP build a new cursor
>but it uses the names of the fields of the last select
>in the case these is present:
<snip>