SQL ISsues

[Bruce Sorge]

Everytime I run this query I receive two records. When I look at the Registration table though, there is only one record. Am I doing the INNERJOINS wrong?   SELECT Registration.Sched_ID, Schedule.Month_Name, Schedule.City, Schedule.Days, Course.Course_ID, Course.Course_Name, Registration.Price,                      Registration.Reg_ID,  Student.First_Name, Student.Last_Name, Student.Company, Student.Email, Student.Title, Student.Where_Learned FROM Schedule INNER JOIN     Registration ON Schedule.Sched_ID = Registration.Sched_ID INNER JOIN Course ON Registration.Course_ID = Course.Course_ID     INNER JOIN Student ON Registration.Student_ID = Student.Student_ID WHERE (Registration.Reg_ID = 842)