compare two sets of first and last name

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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
 
Back
Top