>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
In VFP9 use
insert into Table1 (col1, col2, col3)
select col1, col2, col3 from myCursor cur where not exists (select 1 from Table1 T where T.student_number = cur.student_number)
If it's not broken, fix it until it is.
My Blog