On Wed, Jul 18, 2012 at 10:36 AM, Kurt Wendt <[email protected]> wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not > working this time around. >
I can't remember the name of the setting, but check your SQL Compatibility mode to see of Group By is enforcing that you must make reference to all fields in the SELECT statement. -- Matt Jarvis Eugene, Oregon USA _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAPT54rbDbK+pBBfrOcA=vfrr2td68vuxylzcfm5idij4k1y...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
