>>>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.

?
What do you mean?
First to SELECT and the APPEND FROM?