Re: HAVING column not in select_statement

2003-09-03 Thread Keith C. Ivey
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

RE: HAVING column not in select_statement

2003-09-03 Thread Fortuno, Adam
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,