Looks like there are a couple of other<https://groups.google.com/forum/#!searchin/h2-database/left$20join$20column/h2-database/Du_pl8IkTdg/QnUuiaPvXjEJ> threads<https://groups.google.com/forum/#!searchin/h2-database/left$20join$20column/h2-database/9cnIYyzrn1g/jqNrONnhW70J>along similar lines but I've found that trying to select from multiple tables while also using a LEFT JOIN causes the query to fail with a column not found error. Attached is a sql script to reproduce the issue. Is the following query valid H2 syntax (it is for MySQL & HSQLDB)?
SELECT A.* FROM A, B LEFT JOIN C ON A.ID = C.ID WHERE A.ID = B.ID; ... Column "A.ID" not found; SQL statement: ... Apologies if this is a duplicate. -- 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.
DROP TABLE IF EXISTS A; DROP TABLE IF EXISTS B; DROP TABLE IF EXISTS C; CREATE TABLE A( ID INT PRIMARY KEY ); CREATE TABLE B( ID INT PRIMARY KEY ); CREATE TABLE C( ID INT PRIMARY KEY ); SELECT A.* FROM A, B LEFT JOIN C ON A.ID = C.ID WHERE A.ID = B.ID;
