On Wed, Jul 18, 2012 at 12:36 PM, 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. > > > > 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 > ----------------
Why bring in all the other columns for Vendor, REFNO, REFDATE and Complete if you only wanted it summed to SHIPNO and PONO Either take those columns out of the statement or add them to the group by clause. Because you have the PO# and Ship# you can back track to the table to get the Vendor, REFNO, REFDATE and Complete status if needed. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ 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/CAJidMYLJAf1yhmdNE6V=xkA8+1SK8KF-g0_098iVPgzStf=m...@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.
