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.
