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:..
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
std_idno = pk
rm_stdno = pk
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