Funky GROUP BY

[Balestrieri, John]

OK, thought it was related to the new table... So the only workaround is to
have the fields in the original tables uniquely named across the whole
database? And Alias did not work because the alias 'was out of context'
i.e., it did not carry over to the new table?

(I have an old example of this using valentina 1.x where was working fine...
Standards... meh! :)

John


On 10/11/06 2:38 PM, "Ivan Smahin" <ivan_smahin at valentina-db.com> wrote:

> 
> 1. "... GROUP BY a, b" does not work because aggregation operates with
> "original" fields, but tables have no fields with such names.
> 
> 2.  "SELECT  t1.f1,  t2.f1  ...  GROUP  BY t1.f1, t2.f1" does not work
> because  aggregation  creates  new  table with fields listed in select
> clause. And both fields have to be named "f1" here - so you get an exception.


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.