>
>select Name, address, state from Table1
> union select Name, Address, state from Table2;
> order by 1;
> into cursor TmpResultado
>
>
>Note that ORDER BY can only be done by number.
>
>Hilmar.
Also note that the two (or more) parts of the UNION must
exactly match, in field type, size and decimals. Sometimes, you must fill in information, like:
... union select space(30) as Name... from Table3
Hilmar.
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)