Re: sql question

You cannot group by the column name that you are creating... unless you
wrap another select around this one. But don't go that route,,,, instead
... group by substr(CLIENT_number,1,5)


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.



midrange-l-bounces@xxxxxxxxxxxx wrote on 03/10/2008 11:39:42 AM:

I have a file with an 8 position customer number numeric. I am trying the
following to get the total balance by corporate number (first 5 positions

of

customer number):



SELECT

substr(CLIENT_number,1,5) as corp, sum(BALANCE)

FROM

clfile

GROUP BY

corp

ORDER by

corp





I get the message "column corp not in specified table".



HELP!



Thanks..

--
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.