Re: still dont' get how to group by

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

OK i see I was thinking it was more of a
'control' group by, yes they are fields
CUSTOMER#          DTAWHS             CHARACTER                 8
NAME               DTAWHS             CHARACTER                40
CITY               DTAWHS             CHARACTER                30
STATE              DTAWHS             CHARACTER                 3
COUNTRY            DTAWHS             CHARACTER                 3
ZIP_CODE           DTAWHS             CHARACTER                10
RES_FLAG           DTAWHS             CHARACTER                 1
ZONE               DTAWHS             CHARACTER                 1
ITEM#              DTAWHS             CHARACTER                15
PROD_LINE          DTAWHS             CHARACTER                 3
ITEM_TEXT          DTAWHS             CHARACTER                40
ITEM_WT            DTAWHS             NUMERIC                   7     4
ORDER#             DTAWHS             CHARACTER                 8


On Tue, Dec 31, 2013 at 10:34 AM, Norm Dennis <nhdennis@xxxxxxxxxxx> wrote:

> GROUP BY is field level order of data.
> It looks like you may also have a typo the GROUP BY CUSTOMERr#
>
>
> Norm Dennis
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
> Sent: Tuesday, 31 December 2013 11:04 PM
> To: Midrange Systems Technical Discussion
> Subject: still dont' get how to group by
>
> 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#
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4259 / Virus Database: 3658/6961 - Release Date: 12/30/13
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.