Hi,

You can write the qry in inline view to find out the details,

Here is the sample,

SELECT
S.student_id,
S.mentor_id,
(SELECT name FROM USER WHERE id=S.student_id ) as STUDENT_NAME,
(SELECT type_login FROM USER WHERE id=S.student_id ) as STUDENT_TYPE_LO GIN,
(SELECT name FROM USER WHERE id=S.mentor_id) as MENTOR_NAME,
(SELECT type_login FROM USER WHERE id=S.mentor_id)...