If you are using SET ENGINEBEHAVIOR 80 or 90 the group by clause should have been written as follows:
GROUP BY SHIPNO, pono,vendor,REFNO,REFDATE,Complete (You must list all the fields that do not contain an aggregate function in the group by clause) The way you wrote it only works if your set enginebehavior setting is 70 The above is so you can make your sql statement compatible with SQL Server Rafael Copquin El 18/07/2012 02:36 p.m., Kurt Wendt escribió: > 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. > > > > The actual code is as follows: > > SELECT SHIPNO, PONO, Vendor, REFNO, REFDATE, ; > > Complete, sum(QTYTOT) as Received ; > > FROM Ship_Ln_Cursor ; > > INTO CURSOR Shipment_Lines_List ; > > GROUP BY SHIPNO, pono > > > > I also just checked - and all those fields do properly exist within > Ship_Ln_Cursor. > > Thanks, > > -K- > > > > Senior Developer > > Waitex Information System, Inc. > > P Save a tree. Don't print this e-mail unless it's really necessary. > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
