Hi All,
I have two identical tables, I need to check any unmatched fields every week, what will be the best solution to check that, please help me in detail If possible.
Both tables have more than 100k records
* I need to find any unmatched fields so I can update it and keep both identical.
fields can have numbers and characters.
Table1 from Column A to Column G and Table2 from Column I to Column O ( both tables are identical having the same data)
Please let me know if you have any question?
Thanks
I have two identical tables, I need to check any unmatched fields every week, what will be the best solution to check that, please help me in detail If possible.
Both tables have more than 100k records
* I need to find any unmatched fields so I can update it and keep both identical.
fields can have numbers and characters.
Table1 from Column A to Column G and Table2 from Column I to Column O ( both tables are identical having the same data)
Please let me know if you have any question?
Thanks
A | B | C | D | E | F | G | |
ID | Room | Freezer | Shelf | Rack | Box | Position | |
1 |