Funky GROUP BY

[Ivan Smahin]

Hello John,

Wednesday, October 11, 2006, 9:43:06 PM, you wrote:

> 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?

No.

Again - it will work. And this is following SQL-92 standard.

SELECT
      t1.f1  as 'a',
      t2.f1  as 'b'
FROM
    t1, t2
WHERE
     t1.f1 = t2.f1
GROUP BY
      t1.f1,
      t2.f1
      



-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com