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)