To remove duplicates, or identify mismatching rows, I'd highly suggest partitioning by multiple columns. See this video for information ...
From SQLInSix Minutes
Website:https://www.eclasess.com How to remove duplicate records How to find duplicate Results of join two tables Self join with manager and employee.
From Power BI Online Training by eclasess
Tutorial how to write a SQL Query with Column Aliasing and Order by multiple Columns.
From SQL Server Solutions
How to compare 2 tables in Access - Create a Find Unmatched Query in Access Access 2007, Access 2010, Access 2013 Tutorial How to compare 2 tables in ...
From Tom The PC Trainer Fragale