On Feb 29, 2008, at 6:44 PM, Adrian Klaver wrote:
> HAVING eliminates group rows that do not satisfy the condition.
> HAVING is
> different from WHERE: WHERE filters individual rows before the
> application of
> GROUP BY, while HAVING filters group rows created by GROUP BY.
That's exactly what I've been saying. The rows have been created by
GROUP BY; if you take the result set, there's a column with the alias
you specified. You can use the alias in the GROUP BY, even though the
alias name doesn't exist in the original records. If you can do that,
you should be able to do it in HAVING, since HAVING by definition must
occur *after* the GROUP BY.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
