Hi, I didn't have time yet to fully analyze this, but according to my quick test it doesn't work in all databases.
PostgreSQL: works MySQL: Unknown column 'A.V1' in 'where clause' HSQLDB: user lacks privilege or object not found: A.V1 Apache Derby: Column 'A.V1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
