how to do a reconciliations between two tables?
In that case u need to use inner join based on all the columns required for recon.
Reconciliation based on what ?
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
thanks ashutosh , if possible could u place share an example.