how to do a reconciliations between two tables?

Answer 1

In that case u need to use inner join based on all the columns required for recon.

Answer 2

Reconciliation based on what ?

Answer 3

for example i have 4 columns in common in both the tables, i want to compare if these 4 columns data is same between both tables

Answer 4

thanks ashutosh , if possible could u place share an example.