Re: sql question

you can't use "corp" in that fashion.
SELECT substr(CLIENT_number,1,5) as corp, sum(BALANCE)
FROM
clfile

GROUP BY
substr(CLIENT_number,1,5)

ORDER by
substr(CLIENT_number,1,5)

Thanks,
Tommy Holden



From:
"tim" <tim2006@xxxxxxxxxxx>
To:
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Date:
03/10/2008 10:36 AM
Subject:
sql question



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