SQL Select
From: Mark McCubbin <mccubbin_at_mich.com>
Date: 1997/09/30
Message-ID: <34316AAE.3C99_at_mich.com>#1/1
Date: 1997/09/30
Message-ID: <34316AAE.3C99_at_mich.com>#1/1
I need help with an SQL query to determine which students have taken two or more courses. For example, what is the most efficient way to answer the question: who has taken all three classes CS101, CS200, and CS300?
The tables are as follows (the relationship is one to many):
STUDENT
StudentID
FirstName
LastName
TAKEN
ClassTitle
StudentID
Received on Tue Sep 30 1997 - 00:00:00 CEST