I have two tables (Base Table and Changes Table) with identical fields and field names. All records in the "changes table" need to be moved over to the base table, and the same records within that base table that already exist need to be removed/replaced. I have a field called "supplier code", and that's how i want the query to know when to remove/replace the data.
Basically, the query needs to look at the change table and see what all supplier codes exist, go remove those in the "base table, and replace with the ones in the "change table".
Any help would be appreciated.
Basically, the query needs to look at the change table and see what all supplier codes exist, go remove those in the "base table, and replace with the ones in the "change table".
Any help would be appreciated.