Hi
We don't support JOIN outside of the context of a SELECT.
But you should be able to modify it easily enough to work in all the
databases.
For example, your first query should look like:
SELECT *
FROM
"TABLE1" QVIEW1,
(
SELECT * FROM // <<<<<<<<<<<<<<<<
(
SELECT *
FROM
"TABLE1" QVIEW2
) QVIEW4
JOIN
"TABLE1" QVIEW5
ON ( 1= 1)
) v1
Regards, Noel.
On 2013-07-04 15:43, Mariano Rodriguez Muro wrote:
Hi,
we are having issues with H2 SQL parser. It appears that it is having
problems understanding queries that contain
inline views, together with normal tables and JOIN/LEFT JOIN combined
in the same query.
The error appears only when there are all these things combined (first
a table, then an inline view with both, another inline view and a JOIN
or LEFT JOIN).
It would also seems its only a parsing error.
We include the minimal cases to reproduce it. We tested with Postgres,
MySQL and DB2 and the query is valid in all of them.
Is there any chance to get this one fixed? Is it a hard one?
Thank you in advance
--
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.
