I would like to detailed compare two tables t1 and t2.
Table t1 have 73 columns whereas t2 have 101.
I would like to have a query which returns columns common to both.
There also columns that have been renamed that at times is difficlut to know they are equivalent.
For example CD_AB may have been rename CD_BD but they are suppose to be the same.
The contents of the columns can confirmed it.
Both tables have 3 columns that make up the primary. Two of the columns are common.
How can I make a query to know some columns are common from their contents.