On Mon, 2005-02-21 at 13:48 -0800, Jay wrote: > How about the ability to use the aliased column name in the > where, having, and order by clauses? > > I.E. > > SELECT People, ROUND(Sales,2) AS blah > FROM list_table > GROUP BY People > ORDER BY blah
Works fine when I try it. -- D. Richard Hipp <[EMAIL PROTECTED]>