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

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Display all the records from table using cursor
615
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.