Thanks for the quick response, makes perfect sense. I was deceived by T-SQL and previous h2 versions which allows such queries (I'm doing an upgrade right now from)
Kornel W dniu czwartek, 18 lipca 2013 11:59:45 UTC+2 użytkownik Noel Grandin napisał: > > It's expected. > > When you do a UNION, the resulting "thing" no longer has table names in > scope, only column names. > > On 2013-07-18 11:53, Kornel wrote: > > > CREATE TABLE X ( > num INT, > str VARCHAR(50) > ); > > SELECT x.str, x.num FROM X x WHERE num > 0 > UNION > SELECT x.str, x.num FROM X x WHERE num > 1 > ORDER BY *x.*num; > > DROP TABLE X; > > This does not work! If I remove the table name *x.* however, the query > works. The error is: > > > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
