select r.rid, s.name, s.state, r.rdate, p.name 
from registration r 
inner join user u on u.uid = r.coid
inner join student s on s.sid = r.sid
inner join profile p on p.uid = u.uid