Re: Display all the records from table using cursor

[kaji Pasa]

Here the ID 44 row should not be present as the b.cc>0 is selected to create the table. For suppose this is the case then the requirement will be
if b.cc==0 or b.cc=m.cc then
do nothing
else if
b.cc<> 0 then
set b.cc=m.cc
end if

So the row 53 will be updated as
b.cc=m.cc(i.e after update we get b.cc=3) instead of its current value b.cc=1

my another confusion here is :
The master table is just the same records of base except it can have some variation in m.cc value.
for all the b.cc<>0 we make a temp table and from manual inspection we update or set the value of m.cc. That means if the b.title <> b.title_sci (also corresponding issn from base does not match ) then cc>0 in base so we analyse the title and title_sci in temp table and set the cc to be either 0 or 1 or 2 and push this in master as a repository,So for the next run we use this table to check instead of manual inspection for b.cc<> 0.

My point here is we have all the same rows and same columns for base and master expect cc values. So the join on (title,title_sci,issn1,issn2,issn,eissn ) should give the same number of rows as we have in base report. select count(*) from base_report give 145 rows.
but the join from ur post gives few records.

We have some missing rows from the base_report.