Hi, I just want to ask because i am confuse with my three tables,..my question is..Is it possible to use the join query like the inner join,left join,outer join.,etc...in the 3 tables, as i know that when we use the inner join it must be the pk and fk,example:..

Code:
select e.emp_no, e.f_name,e.l_name,p.proj_no,p.res_empno
from employee e join project p
on e.emp_no = p.res_empno
the emp_no is pk for the employee table and the res_empno is the fk for the project table.

but what if the design of my table is something like this

table1
std_idno = pk
std_fname
std_lname
std_classno

table2
rm_stdno = pk
rm_stdclassno
rm_size
rm_description

I want that if the student has the same classno in the table2 i want to display the rm_size and the rm_description,student name and idno.

Is it possible to use the join query on this,can i populate the exact data?please help me on this I am really confuse....


I am using wamp and i create the database in the phpmyadmin.


Thank you in advance