Re: Display all the records from table using cursor

[kaji Pasa]

master table is repository to make the mapping (match) of such incorrect records we know that will happen,and consider those to be match.so in master table if i have dog=cat and master.cc=0


What i am trying to say is ,
if b.title_sci=b.title, then we get cc=0
if b.title_sci<>b.title
then we have to see the master
if in master this m.title_sci is dog and for the same row m.title= cat then this is match as per the master(a way we say this is match though the column doesnt match in base table ).Hence i need to update cc for this row in the base table to zero which indicates this is a match.