Hi All



Is there a query structure available I can use to identify where records
have been change or are missing between two table with the exact table
structure?



i.e.



I store a backup of financial data annually in separate tables.

JOURNAL2013

JOURNAL2015

JOURNAL2015 etc.

where the main data resides in a JOURNAL table



I need to see only where data has been CHANGED or is MISSING from to JOURNAL
table as compared to data stored in the JOURNAL2014 table.



Regards



Stef





[Non-text portions of this message have been removed]