Hi
You can use UNION clause in Sql

SELECT ...
UNION ALL
SELECT ...

If you want to append from a cursor you must:

APPEND FROM DBF('yourCursor')

HTH


>Borislav
>
>The cursor has been created using:
>
>

>SET TALK ON
>SELECT modacad.mainkey as mainkey, planning.planextra4 as group, planning.planextra1 as element, planning.planextra3 as weight ;
>FROM "U:\Questpdm\Data\modacad.dbf", "U:\Questpdm\Data\planning.dbf" ;
>WHERE modacad.mainkey=planning.mainkey and modacad.mainkey="T56*SS2004*NEIL001*SAMPLE" ;
>AND planning.lev1=1 ;
>INTO CURSOR fablinsty
>SET TALK OFF
>

>
>Then I need to copy those records into a new cursor. I could SQL to a cursor but I need to do the same thing again with another table. Basically I have 2 seperate tables and I want all of the records from both tables into a new table. Therefore I thought I would copy the records from both tables into my newly created cursor.
>
>I have tried the following:
>
>

>CREATE CURSOR crsrisk ;
> (Mainkey c(30), Group C(30), Element C(30), Weight C(10))
>
>APPEND FROM fablinsty FIELDS mainkey, group, element, weight
>

>
>This causes a problem in that when I run this it is saying that it cannot find fablinsty.
>
>Any ideas?