In "there must be a way" department....

I'm trying to copy volunteers from an old table, to a new table. Some of the records from the old table already exist in the new table.

I'm looking to use a single SQL statement to insert records from one table that don't have a corresponding record in another table. something like:

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)

Right now, I'm doing this with SCAN-ENDSCAN....and locate....the old dBase syntax.

TIA