I am performing a matching of 2 different tables. They have the same columns For the research the Query must go through all the data and compare the data in Table a and table b and show the number of cell mismatches and the actual cell where there is a mismatch At this moment I have a Query using the When statement….
WHEN TABLEA.COL1 <> TABLEB.COL1 AND TABLEA.COL2 <> TABLEB.COL2 AND TABLEA.COL3 = TABLEB.COL3 AND TABLEA.COL4 <> TABLEB.COL4 AND TABLEA.COL5 = TABLEB.COL5 AND TABLEA.COL6 = TABLEB.COL6 AND TABLEA.COL7 = TABLEB.COL7 AND TABLEA.COL8 <> TABLEB.COL8 THEN ‘4 FIELDS – COL1 & COL2 & COL4 & COL8’
This is not efficient. Is there any statement that can go through the data automatically and achieve this?