I have two tables in an Access database. Now 1 of these tables (new_table) I would like to compare with the other (old_table) to find out what has changed since the last update.. Both tables has a field called SubCategory3.
I would like to query both tables on category 3 to see what has changed in the new_table because at the moment new_table.subcategory3 contains 600 records and old_table.subcategory3 contains 559 records.
I'm using the following query but think I'm on the wrong track as i'm getting all the identical records from both tables but not the records that have changed :D.
SELECT DISTINCT Table_01.SUBCATEGORY3, Table_011_Old.SUBCATEGORY3
FROM Table_01 INNER JOIN Table_011_Old ON Table_01.SUBCATEGORY3 = Table_011_Old.SUBCATEGORY3;