G
Guest
I have two seperate customer tables and the only way we can identify overlap
is where First Name ( first 3 characters using LEFT([First Name], 3) ), Last
Name and Zip are all equal. The tables are designed as:
Account Number (seperate naming conventions)
First Name
Last Name
Zip
When I use *WHERE Table1.First Name = Table2.First Name, etc. my results are
what I assume are to few. Is there a better way? Thanks.
is where First Name ( first 3 characters using LEFT([First Name], 3) ), Last
Name and Zip are all equal. The tables are designed as:
Account Number (seperate naming conventions)
First Name
Last Name
Zip
When I use *WHERE Table1.First Name = Table2.First Name, etc. my results are
what I assume are to few. Is there a better way? Thanks.