Help with select statement
From: Jen K <jlkilian_at_uwm.edu>
Date: 10 Apr 2003 11:29:23 -0700
Message-ID: <170db79d.0304101029.f09b0c2_at_posting.google.com>
Date: 10 Apr 2003 11:29:23 -0700
Message-ID: <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
Received on Thu Apr 10 2003 - 20:29:23 CEST