Get the list of all the (reviews and papers) which has been reviewed by reviewer and also get the author name for that list of the paper.
Schema :
AUTHOR:{a_id,a_first_name,a_last_name,a_phone_no,a_email,a_pwd}
PAPER: {paper_id,title,abstract,file_name,author_id}
REVIEWER:{rvr_id,rvr_first_name,rvr_last_name,rvr_phone,rvr_email,rvr_pwd,rvr_interest}
REVIEW:{rv_id,clarity,relevance,technical_rate,rvr_id,paper_id}
**THIS IS A BIT INTIMIDATING FOR ME**
THANK YOU VERY MUCH. GOD BLESS YOU.
Best Answer
solved it Here is the query for this question :-- Is there any other way to solve it ?
select a.a_first_name,p.title, rr.rvr_first_name,r.rv_id,r.clarity,r.relevance,r.technical_rate
from review r
join reviewer rr on rr.rvr_id = r.Rrvr_id
join paper p on r.p_id = p.paper_id
join author a on p.author_id = a.a_id;
