I did. I tried that before I sent my post. Same error message.
> -----Original Message----- > From: Dean H. Saxe [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 4:29 PM > To: SQL > Subject: Re: GROUP BY clauses > > Using GROUP BY you must include all columns returned by the query which > are > not aggregates (e.g. SUM, COUNT, MIN). > > e.g. > > SELECT > foo, > bar, > blah, > count(foobar) as count_foobar > FROM > table > GROUP BY > foo, bar, blah; > > If you remove any of the columns from the GROUP BY clause you will receive > > the error you mentioned in your post. > > HTH, > > -dhs > > At 04:17 PM 12/6/01 -0500, you wrote: > >I'm using SQL Server 2000. > >I wrote query using the GROUP BY clause, but an error gets thrown saying > the > >columns are > >"invalid in the select list because it is not contained in either an > >aggregate function or the GROUP BY clause" > > > >I did some digging and found something called the "GROUP BY Support > >Property" > >I'm not sure, but it looks like I can change the behavior of the GROUP BY > >clause. > >Does anyone know if this is true, and how do I do it? > >Else, why is the GROUP By clause throwing me the error? > >Matt > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
