Sql Help

[lovesirius12]

SQL = "SELECT CLASS_SCHEDULE.C_SubjectName, CLASS_SCHEDULE.C_TimeStart, CLASS_SCHEDULE.C_TimeEnd, CLASS_SCHEDULE.C_DaySched FROM STUDENT_SUBJECT INNER JOIN CLASS_SCHEDULE ON CLASS_SCHEDULE.C_SubjectCode = STUDENT_SUBJECT.S_SubjectCode WHERE CLASS_SCHDULE.C_Course_Code = STUDENT_SUBJECT.S_CourseCode AND CLASS_SCHEDULE.C_YearLevel = STUDENT_SUBJECT.S_YearLevel AND CLASS_SCHEDULE.C_Semester = STUDENT_SUBJECT.S_Semester AND STUDENT_SUBJECT.S_Number = '" & S_Number & "'"

there's an error here but i cant seem to see whats the problem. please help. thanks

[Roelf]

I think it should be like this:

SQL = "SELECT CLASS_SCHEDULE.C_SubjectName,
CLASS_SCHEDULE.C_TimeStart,
CLASS_SCHEDULE.C_TimeEnd,
CLASS_SCHEDULE.C_DaySched
FROM STUDENT_SUBJECT INNER JOIN CLASS_SCHEDULE ON
CLASS_SCHEDULE.C_SubjectCode = STUDENT_SUBJECT.S_SubjectCode
AND CLASS_SCHDULE.C_Course_Code = STUDENT_SUBJECT.S_CourseCode
AND CLASS_SCHEDULE.C_YearLevel = STUDENT_SUBJECT.S_YearLevel
AND CLASS_SCHEDULE.C_Semester = STUDENT_SUBJECT.S_Semester
WHERE STUDENT_SUBJECT.S_Number = '" & S_Number & "'"