Hi! The SQL Standard doesn't allow derived tables with neither correlation names nor (not supported by H2) recognition clauses, so your original SQL isn't Standard-compliant.
Some database systems forbid such SQL, some others allow it, but correlation name is still required and H2 generates it in that way. If such generation creates problems for you, add some correlation name by yourself to the original query. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/h2-database/58e1661d-a2a9-4696-b9ef-882196ba5e28n%40googlegroups.com.
