Include your query
At 04:37 PM 12/6/01 -0500, you wrote: >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
