Re: How to write an SQL for this?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Feb 2004 17:27:23 -0800
Message-ID: <2687bb95.0402191727.7832842@posting.google.com>

"*****ron******" <ronaldl._at_flymail.fm> wrote in message news:<c12s2a$1cvmo1$1_at_ID-28118.news.uni-berlin.de>...
> "S. D" <d_danturthi_at_hotmail.com> wrote in message
> news:29bbbe51.0402190922.4af86c24_at_posting.google.com...
> > 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!
> Are you doing the same course I'm doing. Post the answer here when you get
> it
> Ron

"multiple professors teach same course. No one prof can teach it all by himself."

With specifications like these no wonder IT never delivers what the customer wants.

HTH -- Mark D Powell -- Received on Thu Feb 19 2004 - 19:27:23 CST