I have 2 tables, I will simplify the situation. Say I have table1, it has the fields "ID", "Tag", "Date", and table2 and the fields "ID" "TAG". Table1 contains an old version of the dataset, and table2 is updated every so often.
I want to do two things. First, I want to update Table1 with the new dataset on the either automatically or with the click of a mouse with the data that is in Table2.
The other thing I want to do is I want to check that the data in Table1 is not unique, ie, if a value exists in table1 and not in table2, I want it removed, but I want it moved to a table called Dump so it can be reviewed before it is removed.
Take this as an example
Table1 "Tag" dataset
Tag1
Tag2
Tag3
Tag4
Table2 "Tag" dataset
Tag1
Tag2
Tag4
Tag5
This will become
Table1 "Tag" dataset
Tag1
Tag2
Tag4
Tag5
Dump "Tag" dataset
Tag3