Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Select

SQL Select

From: Mark McCubbin <mccubbin_at_mich.com>
Date: 1997/09/30
Message-ID: <34316AAE.3C99@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US