MySQL Forums
Forum List  »  Stored Procedures

Re: Display all the records from table using cursor
Posted by: Peter Brawley
Date: September 25, 2017 01:36PM


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 <> 0;

(Seriously, your university tracks SSNs with up to four SSN values per person!? A lot of things wrong there.)


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

I don't understand "dog=cat", I'm stuck till that's clarified.

Options: ReplyQuote

Written By
Re: Display all the records from table using cursor
September 25, 2017 01:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.