>Hi Frank,
>
>I want it like result 2
>
>>you have:
>>
>>

Table1
>>Field1, Field2, Field3
>>aaaaaa, bbbbbb, cccccc

>>
>>and
>>
>>

Table2
>>Field1, Field2, Field3
>>dddddd, eeeeee, ffffff

>>
>>and is your result is to look like this:
>>
>>
>>

Result2
>>Field1, Field2, Field3
>>aaaaaa, bbbbbb, cccccc
>>dddddd, eeeeee, ffffff

>>

SELECT Field1
         ,Field2
         ,Field3
   FROM Table1;
UNION ALL;
SELECT Field1
         ,Field2
         ,Field3
   FROM Table2;
INTO CURSOR Result2