Re: Help with select statement

From: Joel Garry <joel-garry_at_home.com>
Date: 14 Apr 2003 18:46:51 -0700
Message-ID: <91884734.0304141639.ddb927c_at_posting.google.com>


jlkilian_at_uwm.edu (Jen K) wrote in message news:<170db79d.0304110643.425e779b_at_posting.google.com>...
> > Too lazy to try it, but maybe
> > select studentID from ... having count(courseID) = (select count(*) from catalog)
> > group by studentID
> >
> > jg
>
> I can't seem to get this to work...perhaps I don't understand what the
> statement should be exactly.

What error do you get? The idea is that the having statement is determined by the catalog count.

jg

--
_at_home.com is bogus.
April showers clog up freeways.
Received on Tue Apr 15 2003 - 03:46:51 CEST

Original text of this message