Re: still dont' get how to group by

Hi

Others have answered your question.

I have an idea, for better understanding of SQL - take the tutorial at w3schools.com - they have really excellent stuff, and this tutorial will _almost_ all apply to IBM i SQL, as well as almost any other RDBMS, such as MySQL or SQL Server or whatever.

Note the "almost" - there are functions in the tutorial that we don't have on IBM i - we have something that will get the same thing, usually - examples are things like FIRST() and LAST().

There's also a nice menu for all kinds of things, including "SQL GROUP BY" - this is useful when looking for something specific.

The link is at http://www.w3schools.com/sql

I heartily recommend this or some other tutorial. There's everything in the SQL Reference for DB2 on IBM i, but it's not always easy to find one's way into it.

HTH
Vern

On 12/31/2013 9:03 AM, Hoteltravelfundotcom wrote:

Why does this group by not work, what is it I need to do?

Column NAME or expression in SELECT list not valid.
CREATE VIEW PROJ_CRWN1/DATA_WHSV2 AS SELECT CUSTOMER#, NAME, STATE,
ITEM#, PROD_LINE, INVOICE#, ORD_DATE, INV_DATE, ORD_TYPE,
CUST_TYPE, QUANTITY, EXTENDED$ FROM Proj_Crwn1.DTAWHS
GROUP BY CUSTOMERr#