Funky GROUP BY

[Balestrieri, John]

On 10/11/06 12:36 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> Actually this is EXPECTED and CORRECT result according to SQL92.

OK... Never said it was wrong though, only that it worked in other SQL
engines, including Valentina 1.x, and that I needed help in making it work
with V2. :)

> 
> If you want have it in SELECT, you MUST include it into GROUP BY.
> 

Got it, thanks!

John


The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1898 and delete this email. Thank you.