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...