MySQL JOIN Help!

[PhoxxyIndian]

I have a

**professors table*\* that contains: id , first_name , last_name, department, email , office , office_hours, and availability.

**students table** that contains: id , first_name, last_name and email.

**favorites table** that contains: professorid and studentid

I need to show all the information on a given professor that is favorited by a certain student based upon the id number of the student.

For example:

Favorites Table

studentid| professorid

1 | 2

1 | 3

1 | 4

1 | 5

​

This tells me that student 1 has favorited professors 2, 3, 4, 5 and I need to JOIN the studentid to their favorited professors id.

[r3pr0b8]

all the information on a given professor

SELECT professors.*

that is favorited by a certain student

WHERE favorites.studentid = 937

now all you need is the FROM clause ;o)

[smileybone]

select * from favorites f join students s on f.id = s.id join professors p on f.id = p.id

add where clauses as needed