I need visual foxpro help please?

Question

i have a table called altable with 9130000 telephone records and a table called final with 3000000 telephone records. altable, is every possible telephone numbers that voted republican. and final table are just random telephone numbers. I need the script that will compare the two tables, so that i have just the unique numbers. and the 3000000 records are taken from the table with 9130000
i know that the code should look something like this
use altable
select 0
use final
index on phone ...................... to t unique
i think it is supposed to be something along those lines
please help

Answer 1

use this

select * from final where final.phone in (select altable.phone from altable)

this will work fine.

Answer 2

I would just export it to Access and use the duplicates wizard.

Sorry, I dont know much about Visual FoxPro.