On 3 Sep 2003 at 15:43, Stefano Fraccaro wrote:
I have a query with a column in HAVING clause that not refer any
column listed in SELECT statement because I don't need to group by
this column and ... this query don't work. It's possible or this
feature is planned for the future?
Can you give
Stefano,
OOh! You're taking me back a few years. As best I remember, the 'HAVING'
operator applies to the results returned by the query not in shaping the
results to be generated. For example, if you have a table that stores
trouble tickets per user. You select the user's last name, first name,