I have a DB with 2 Tables, List1 and List2 (both tables have the same fields, Name, Address and Phone)
I want to run a query that will compare, say, the Name field from Table1 against Table2 and return the matching values.
IT IS NOT THIS SIMPLE THOUGH! – for eg in Table1, the Name1 is Paula...