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 -> Re: How to write an SQL for this?

Re: How to write an SQL for this?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 19 Feb 2004 15:35:17 -0800
Message-ID: <1077233676.23611@yasure>


S. D wrote:

> Thanks in advance.
>
> Two tables - professors and courses. Additional table for term (has
> year, semester fields)
>
> Need an SQL statement for the following. No complicated statements
> required but a simple one will do.
>
> "multiple professors teach same course. No one prof can teach it all
> by himself."
>
> Any help is appreciated. Thanks again!

We don't do people's homework for them ... we only provide hints.

My hint to you ... put some effort into it and then post your best attempts. We will try to get you on-track where you missed the mark.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Feb 19 2004 - 17:35:17 CST

Original text of this message

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