MySQL Select statement - any one any good at MySQl/SQL

[maxvee8]

hi i need to select all from teaching session where the couse course code... but there is no course code in teaching sessions only in the CourseModule table and Course,

a course contains many modules so how would i get all of the modules from searching a course and display all the teaching sessions for those modules that are in the course...

baffled...any one know?

http://img136.imageshack.us/img136/6364/ddak1.jpg

[Deacon Frost]

mysql_query( SELECT * FROM table WHERE course="TeachingSession" )


I think that's what you're wanting?

Show us your table, and try and be a little less vague. You know what you mean, we don't :).