0

I have the following three tables:

ClassHeader
ClassID
Major

TeacherClasses
TeacherID
ClassID

StudentClasses
TeacherID
Major

I want to select all TeacherClasses where the a given Major = ClassHeader.Major

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by tim8w
0

I have the following three tables:

ClassHeader
ClassID
Major

TeacherClasses
TeacherID
ClassID

StudentClasses
TeacherID
Major

I want to select all TeacherClasses where the a given Major = ClassHeader.Major

A user on another Forum gave me this solution which worked:

SELECT TeacherClasses.TeacherId, TeacherClasses.ClassId
FROM ClassHeader INNER JOIN TeacherClasses ON TeacherClasses.ClassID = ClassHeader.ClassID
WHERE ClassHeader.Major = 'BasketWeaving'
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.