On Friday 29 February 2008 5:01 pm, Ed Leafe wrote: > 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 > All I can do is point you back to this message for the explanation: http://leafe.com/archives/showMsg/379898
-- Adrian Klaver [EMAIL PROTECTED] _______________________________________________ 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]
