Comparing data in two tables with different columns

Assuming the columns have the same name:

1. In the query editor, add a manual "source" column.
   1. The value will be [Table 1 name] and [Table 2 name]
2. Union these 2 tables ("Append Queries" in the query editor).
3. Create a matrix on the new, appended table.
   1. Each coulumn in the table will go into the matrix values as distinct count
   2. "Source" will go into the matrix columns
4. If the tables are the same, "distinct count" of any column will show Table1 = Table2 = Total
5. You can expend on that by adding ID fields to find the difference if needed.