How to compare three columns data from different data bases

Question

I have one table name table1 with columns (column 1, column 2, column 3)in Microsoft SQL server and another table in table 2(column 1, column 2, column 3) in Oracle database .how can compare these tables data . tables are having 10lakhs plus data

Answer 1

What kind of comparison do you want to do?

Answer 2

You would have to reference it like table1.columnname, table2.columnname etc as long as the tables are in the same db it should work. Happy coding