How to go about comparison of data between two tables ?

Database

How to go about comparison of data between two tables ?

Hi All,

I need to compare two tables in teradata, both in differnt databases and with differnt structure. But column names are matching. How to do the same.

Please help.