Thanks, ALex - that would explain it.

My previous experience of UNION (with FoxPro particularly) did NOT allow
the fields to be of different names in the selects - they had to match
exactly for name, type, size. I would get a mismatch error.

Still, now I know how FB handles things, I can make the necessary
adjustments to code.

Cheers
Terry

----------Original Message---------

> 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
>