Link to home
Create AccountLog in
Avatar of Clifton Bardwell
Clifton BardwellFlag for United States of America

asked on

Searching for Records With First And Last Names

I have two tables something like this:

Table_1
President          Term
George Washington  1789-1797
Adams, John        1797-1801
Thomas Jefferson   1801-1809
James Madison      1809-1817
Monroe, James      1817-1825
John Quincy Adams  1825-1829

Open in new window


Table_2
LastName    FirstName    Party
Washington  George       Independent
Adams       John         Federalist
Jefferson   Thomas       Democratic-Republican
Madison     James        Democratic-Republican
Monroe      James        Democratic-Republican
Adams       John Quincy  Democratic-Republican

Open in new window


What I'm looking for is a query that will return records from Table_1 where there's a match (by FirstName and LastName) in Table_2.

The hitch in this here giddy up is that the names in Table_1 might be First-Last or Last-First (and, in the real data, there might be a salutation of Mr., Ms, or Dr.)

TIA
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Are the titles ONLY Mr., Ms, or Dr. ?
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Clifton Bardwell

ASKER

That seems to work.  Thanks.  :-)