Re: Help with aggregate SQL

From: tacnaboyz <fake.address_at_fake.fake>
Date: Wed, 07 Aug 2002 04:51:36 GMT
Message-ID: <sH149.3454$2k.219125@newsread1.prod.itd.earthlink.net>

No, it's not a homework assignment. I guess the reason I said that was because this is just PART of a larger, more complex query and I didn't think I would would be able to make it work with the rest of the query by messing with the 'group by' clause. However, I have since lowered my expectations (which was to do everything I needed to do in one query). So assuming we can scratch that comment, can you offer a solution? It's got me stumped.

Thanks

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uy9bj6rou.fsf_at_hotpop.com...
> On Wed, 07 Aug 2002, fake.address_at_fake.fake wrote:
>
> > the only column I can have in my "GROUP BY" clause is "STATE".
>
> Where did such a silly restriction come from? Is this a homework
> assignment?
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Tue Aug 06 2002 - 23:51:36 CDT