Compare two tables and show uncommon data
Posted on 2004-09-09
I've got 2 tables in a database, both have the same structure. One table is from month X, one is from month Y. I'm trying to figure out how to set up a query with the queries function (ether design or wizard) will output a third table, that table containing only data records which do not appear in both the source tables (basically, new entries in month Y). The fields are "first & middle name", "last name & suffix", "street 1", "street 2", "city", "state", "zip code" - standard mailing list stuff. None of those fields is the primary key, that is a field called "id" which appears to be unique, but I don't know what it is keyed from.
Thanks in advance