MySQL query Woes - joining data from two or more tables

[africanshox]

im creating a quick form that retrieves a list of schedules based on the course

http://www.interquad.com/search/scheduleSelector.asp


now within my Mysql database i have the following simple tables

Course: CourseID,CourseName,TeacherID,coursefee,max

Enrollment:StudentID,CourseID

Students:StudentID,Firstname,Surname,BirthDate

Teachers:TeacherID,FirstName,Surname


my approach was to create a new table called course_schedule so that i can use it to create a start_date,location,num_enrolled.


can anyone please help me as to how i can approach this in order to achieve the form shown on http://www.interquad.com/search/scheduleSelector.asp

thank you

From a Desparate Newbie!