Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to write an SQL for this?
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
![]() |
![]() |