RE: sql question

[rob@xxxxxxxxx]

But the devil is in the details.

Why can I do this:
SELECT 
substr(digits(CLIENT_number),1,5) as corp,
sum(Balance) as BalanceSum 
FROM 
qtemp.clfile 
GROUP BY substr(digits(CLIENT_number),1,5)
ORDER by substr(digits(CLIENT_number),1,5)

But this
with t1 as ( 
SELECT 
substr(digits(CLIENT_number),1,5) as corp,
sum(Balance) as BalanceSum 
FROM 
qtemp.clfile 
GROUP BY substr(digits(CLIENT_number),1,5)
ORDER by substr(digits(CLIENT_number),1,5)
) 
select corp, BalanceSum 
from t1 
order by BalanceSum desc 
fetch first 25 rows only 

Tells me that 
SQL0122-Column CLIENT_NUMBER or expression in SELECT list not valid.

Rob Berendt