Need help joining tables...
- by yuudachi
I am a MySQL newbie, so sorry if this is a dumb question..
These are my tables.
student table:
SID (primary)
student_name
advisor (foreign key to faculty.facultyID)
requested_advisor (foreign key to faculty.facultyID)
faculty table:
facultyID (primary key)
advisor_name
I want to query a table that shows everything in the student table, but I…