Subject Re: [firebird-support] ORDER BY in UNION SELECT
Author Alex Taylor
The UNION statement enables you to merge result sets with identical
field types, but it allows using different field names in different
result sets on the same position. Thus You cannot reference the merged
result set's fields by name. This is the normal behavior.

Regards:Alex