>>Union needs order by the field # (order by 5,6), not field name.
>
>Thanks! Why is that?
'cause the fields may have different names in the different parts of the UNION.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)