Search results

  1. 1

    Non matching address query

    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...
  2. 1

    Non matching address query

    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!
  3. 1

    Non matching address query

    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...
Top Bottom