i dont' think i want to join the tables....i want to create a new table that lists the ones from table 1 that dont' match table 2

thanks that worked

Ray M the only problem i have is that i have a huge db and i dont' want to have to type in the pairs....

thanks i will see if it works

its classified. but let me see what i can do

i want it to look like this

id1     / (matches)     id2/   fingerprint  /face match        /reasons

aaaa                    bbbb        yes           yes            applying for job, got job

table...