>Tables don't have the same struct
>
> But all them contains the fiels: Name, address, State...
>
> Is it possible select only those fields ?
>
> Moises
Yes, just select the individual fields instead of using "*".
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.
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)