Hi everyone,
Could someone please help me out. I am having problems retrieving information from a table where 2 attributes are foreign keys of the SAME attribute in another table....
The tables are
USER(id, name, type_login)
STUDENT(student_id, mentor_id)
here, student_id and mentor_id are foreign keys of the USER table....
I need to get a list of all the students with their respective mentors....
I think the problem is because we are referencing the same coloumn of the user table....
Looking forward to a reply soon!
Thanks & Regards
Gunjan