President TermGeorge Washington 1789-1797Adams, John 1797-1801Thomas Jefferson 1801-1809James Madison 1809-1817Monroe, James 1817-1825John Quincy Adams 1825-1829
LastName FirstName PartyWashington George IndependentAdams John FederalistJefferson Thomas Democratic-RepublicanMadison James Democratic-RepublicanMonroe James Democratic-RepublicanAdams John Quincy Democratic-Republican
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.)