compare two sets of first and last name

[Chris]

I have two tables of first and last names and I am trying
to come up with a query that can go through and compare
the two tables to find the exact matches of first and
last name. Any help is appreciated...
Thanks you,
Chris

 

[Michel Walsh]

Hi,



Make an inner join, on the two fields:


SELECT ta.firstName, ta.lastName
FROM ta INNER JOIN tb
ON ta.firstName = tb.firstName
AND
ta.lastName = tb.lastName



if the table names are ta and tb.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

you are a genious.
guess I was making much to complicated... thank you