select last, .t. AS volunteer, person AS oldid ; from volunteer; where Person not in (select oldId from person); into CURSOR Temp select person append from ( DBF("Temp")) USE IN TempVFP8
INSERT INTO person (last,first,volunteer,oldid); SELECT (volunteer.last,volunteer.first,.t.,volunteer.person) ; FROM volunteer ; WHERE volunteer.person NOT IN (select oldid FROM person)>In "there must be a way" department....
>INSERT INTO person (last,first,volunteer,oldid); >VALUES (volunteer.last,volunteer.first,.t.,volunteer.person); >WHERE volunteer.person NOT IN (select oldid as person FROM person) >>