>>I have Table1 and Cursor1
>>
>>Both have student_number field.
>>
>>What I need to do is:
>>
>>Select table1
>>
>>Append from cursor1 ( but only student_number that still does not exist in table1)
>>
>>Moises
>
>

>INSERT INTO Table1 (field list here);
>SELECT field list here;
>FROM Cursor1;
>LEFT JOIN Table1 ON Table1.Student_Number = Cursor1.Student_Number;
>WHERE Table1.Student_Number IS NULL
>

I'm a little mechanical in my approach but I would query the cursor into a "final" cursor for the append, thus eliminating the items I did not want.