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]

Reply via email to