Hello, I am trying to compare mailing addresses between two tables.
Table 1: Products Shipped (Contains Product #'s and addresses they were shipped to)
Table 2: Correct Address (Contains all Product #'s and their correct mailing address)
Is this the best approach?:
Query table 1 to concatenate Product number, street #, city, & state
Query table 2 to concatenate the same as above.
Create a query that joins table 1 & 2 by the concatenated columns & change the join to show all table 1 records and only records from table 2 that match
Query the results to show all fields where the concatenated address column from table 2 is blank ( = " ") (For some reason is null doesn't work)
Q2.If the above is the best approach, why do I receive more records in the results then what is listed in table 1? I need the results to match the total of items in table 1. (There currently isn't a primary key set up & I haven't grasped that concept yet; if that is the cause of all the extra records pulling in, can you please explain which columns should be the primary key & why?
Thank you for taking the time to read and respond!!!
Table 1: Products Shipped (Contains Product #'s and addresses they were shipped to)
Table 2: Correct Address (Contains all Product #'s and their correct mailing address)
Is this the best approach?:
Query table 1 to concatenate Product number, street #, city, & state
Query table 2 to concatenate the same as above.
Create a query that joins table 1 & 2 by the concatenated columns & change the join to show all table 1 records and only records from table 2 that match
Query the results to show all fields where the concatenated address column from table 2 is blank ( = " ") (For some reason is null doesn't work)
Q2.If the above is the best approach, why do I receive more records in the results then what is listed in table 1? I need the results to match the total of items in table 1. (There currently isn't a primary key set up & I haven't grasped that concept yet; if that is the cause of all the extra records pulling in, can you please explain which columns should be the primary key & why?
Thank you for taking the time to read and respond!!!