Re: Help with select statement

jlkilian_at_uwm.edu (Jen K) wrote in message news:<170db79d.0304101029.f09b0c2_at_posting.google.com>...
> hi,
> My professor has asked us to create a Select statement that even he
> can't seem to figure out. We would like to know the Student IDs of
> students who have enrolled in every class offered. Here is a very
> simplified table structure (:
> Student(studentID[pk], sName)
> Catalog(courseID[pk], cName)
> CourseSchedule(termNo[pk], courseID[references catalog.courseID])
>
> Can anyone help?
> Thanks!
> Jen

First you need some kind of relationship between Student and CourseSchedule. Received on Fri Apr 11 2003 - 17:48:16 CEST