Results 1 to 9 of 9
Thread: Need help for my tables
Dec 15, 2012, 08:28 #1
- Join Date
- May 2012
- 0 Post(s)
- 0 Thread(s)
Need help for my tables
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
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