Quote
role of CC: if base.title_sci = base.title or b.issn1=b.issn2 or b.issn=b.eissn then this is match and CC=0 else cc=1 .
where cc is not zero then i have to see those records in a master table.
In SQL, that would be ...
select m.*
from b
join m using(title_sci,title,issn1,issn2,issn,eissn)
where b.cc <> 0;
(Seriously, your university tracks SSNs with up to four SSN values per person!? A lot of things wrong there.)
Quote
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
I don't understand "dog=cat", I'm stuck till that's clarified.