How to write an SQL for this?

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! Received on Thu Feb 19 2004 - 11:22:16 CST