On 09/10/2010 02:48 AM, Chris Wilson wrote: > I'd like to be able to use a column alias (from the column list of the > SELECT statement) in the HAVING clause. ... > Derby clearly knows this, as using the expression instead of the alias > works:
After fairly extensive discussion (see this issue for a good overview: https://issues.apache.org/jira/browse/DERBY-2457), the community decided, I believe, that this was correct behavior according to the SQL standard. thanks, bryan