Join Problem 1

[dagger2002]

Here is the basic query with no joins. But it is giving me a 1064 error.

I am running mysql 4

SELECT 
     school.cdsCode, school.dist_cdsCode, school.sname, 

     class.clas_id, class.clas_semester, class.clas_sMonth, 
     class.clas_sDay, class.clas_eMonth, class.clas_eDay,      
     class.clas_sTime, class.clas_eTime, class.clas_dayM, 
     class.clas_dayT, class.clas_dayW, class.clas_dayTH, 
     class.clas_dayF, class.clas_dayS, class.clas_blo, 
     class.clas_active, class.cour_id, class.schoo_cdsCode, 
     
     course.cour_id, course.cour_name, course.cour_active 

WHERE 
     class.cour_id = course.cour_id AND 
     class.schoo_cdsCode = 
     school.cdsCode AND class.clas_id = 4 

ORDER BY course.cour_name

Can any one tell me my error?

 

[elsenorjose]

No 'From'?

From class, course, school
WHERE
class.cour_id = course.cour_id AND
class.schoo_cdsCode =
school.cdsCode AND class.clas_id = 4

 

[r937]

no join?

  FROM class
INNER
  JOIN course
    ON course.cour_id = class.cour_id 
INNER
  JOIN school
    ON school.cdsCode = class.schoo_cdsCode
 WHERE class.clas_id = 4

r937.com | rudy.ca

 

[elsenorjose]

Doesn't MySQL support 'old' style joins?

 

[r937]

yes, it does, but why would you write them old style when the new style is so much better

r937.com | rudy.ca

 

[elsenorjose]

I dunno. But OP was using old style syntax. Didn't wanna confuse the issue

 

[guelphdad]

neither is the OLD style, the first is list syntax and is a poor way to learn to do joins, partcularly as joins get more complex. it is easier to leave conditions out of your join when you do it that way.

unfortunately mysql manual emphasizes using those types of joins even though it is easier to make errors with them.