Access Query: Finding match in another table

I have 2 tables See below...

table1: Columns: "FirstName", "LastName", "First_Match", "Last_Match"
table2: Columns: "FirstName", "LastName"

both tables have over 100,000 records in them.

I would like a query that will enter "Match" in table1 (In the "First_Match" column) if the "FirstName" exists in table2.

I would also like the query to enter 'Match in table1 (In the "Last_Match" column) if the "LastName" exists in table2.

how would I do this? (It's been a long time since I used Access 97)
ouestqueAsked:
Who is Participating?
 
JezWaltersCommented:
These two queries should do what you're after:

    UPDATE table1, table2
    SET table1.First_Match = "Match"
    WHERE table2.FirstName = table1.FirstName

    UPDATE table1, table2
    SET table1.Last_Match = "Match"
    WHERE table2.LastName = table1.LastName
0
 
ouestqueAuthor Commented:
thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.