>I can't figure this one out...
>
>This command doesn't work:
>>SELECT 'Sold' as Dataset,* from sold ;
> UNION select 'Mailed' as Dataset,* from mailed ;
> ORDER BY cRow INTO CURSOR temp
>
>
>This command DOES work:
>>SELECT 'Sold' as Dataset,* from sold ORDER BY cRow INTO CURSOR temp
>
Besides what Gunnar told you about the order column, consider that Union works if both table columns (fields) being returned are the same. You used * in both. Are the two file structures the same?