Rather than using the NOT IN predicate try using NOT EXISTS,
maybe Foxpro would be faster with this instead:

SELECT col1 ;
FROM table2 ;
WHERE ;
NOT EXISTS ;
(SELECT col1 ;
FROM table1 ;
WHERE table1.col1 = table2.col1)