...Both tables should have the same structure during the run. Insert and Update query's are created during the run and can be saved for later execution.
Joins can be added to the from query if only certain records should be compared, as long as the end result only have the current table fields visible.