Searching equal records

[CMontoro]

I have two tables named PERSONAL and CUSTOMER
PERSONAL table has fields : ID_PER, P_LASTNAME, (key = ID_PER)
CUSTOMER table has fields : ID_CUS, C_LASTNAME, (key = ID_CUS)

I need a process to review each LASTNAME in PERSONAL table and to search if there is a equal LASTNAME in CUSTOMER.

How can I identify equal records and to save them in another table named EQUALS ?

Thanks in advance
Carlos

 

[ejstefl]

Create a new query. Add CUSTOMER and PERSONAL. Link P_LastName to C_Lastname (and any other fields that you want to be equal).

Bring down whatever fields you want in the new table.

Change your query to a make table query, and run it.

 

[CMontoro]

Hi EJSTEFL
Thanks for you answer, but I need to review each record. Something like that:

do while not eof()
compare PERSONAL_lastname with CUSTOMER_lastname
if p_lastname = c_lastname then
save p_lastname in Table EQUALS
endif
skip
enddo

Thanks again
Carlos

 

[ejstefl]

Not sure I understand... the query I posted will put each record that LastName in a new table if it exists in both tables. Is this not what you need to do?