>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.