How to combine 3 tables by SQL?

[happy_karen]

Hello, I want to ask how to combing the following sql since there are 3 tables totally needed to join?

The tables are:
score
-fields are: scoreid, sid, case_no, effort, Time
weekt
-fields are: weekid, datefrom, dateto, case_no

One SQL:
SELECT * FROM score, weekt where weekt.weekid='1' and score.case_no=weekt.case_no order by score.sid, score.case_no, score.scoreid;

Another SQL:
select * from student where sid = 'FROM ONE SQL STATEMENT';

How to combine using JOIN??

Thanks a lot!!

[happy_karen]

sorry, forget to explain more:

student table fields are:
sid, Name

thanks!

[Jorge Solis]

Ooops, miss this thread. Just in case you didn't solve, consider to have a common column in the tables you need to have a relationship

Jorge

[Ronald Wernecke]

you can use implicit outer join, or write the join, which matches best.

implicit would look like this:

Code:

SELECT * FROM student, score, weekt where student.sid=score.sid and score.case_no=weekt.case_no and weekt.weekid='1' order by score.sid, score.case_no, score.scoreid;

try it out with phpMyAdmin, before you use it in your code.

BTW: you should never use select * - better use explicit fieldlist.
Even when you are requesting all fields, performance will be much better.
And if you join tables, with * you receive all joined fields twice - once from one, and another time from the other table - this does not realy make sense, just for saving a few seconds typing