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>
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