Hello Dale, these tables were created from queries that are stored in different databases and were not intended to have a relationship. I concatenated the results in order to create a relationship. I left out this information so the example would be simple and easy to answer. This data is as...
Hello Dale, please elaborate... Can you explain what detail from the example lead you to a normalization issue? Also, I am still looking for an answer to the question posted. (Is that the best approach to retrieve the data?)
Thanks!
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...