Bill:
In your formulation, 'ORDER BY Stack DESC' now performs as expected. Thanks for the clarity. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Sunday, June 09, 2013 7:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: FAIL: SELECT (expression) AS alias Bruce, You cannot "group by" a column that is used in an aggregate function (count, sum, min, max, avg). Turtle cannot be both after select and also the column in the count expression. Maybe you want something like: SELECT Turtle, COUNT(*) AS Stack + FROM Salamasond + WHERE KingOfThemAll LIKE 'Yertle' + GROUP BY Turtle + HAVING COUNT(*) > 10 + ORDER BY Turtle On Jun 9, 2013 9:50 PM, "Bruce A. Chitiea" <[email protected] <mailto:[email protected]> > wrote: All: I would like to 'ALIAS' an expression in a SELECT statement: SELECT Turtle, COUNT(Turtle) AS Stack + FROM Salamasond + WHERE KingOfThemAll LIKE 'Yertle' + GROUP BY Turtle,Stack + HAVING Stack > 10 + ORDER BY Stack,Turtle ... or column names to that effect, but what I get is an: -ERROR- Column stack not found (2369) Is there a way to 'package' the expression to have Mack's 'stack' recognized? Thanks Bruce Chitiea SafeSectors, Inc. eCondoMetrics
