title: Cannot Use Joins in H2 Database
body: <p>I am running into a strange issue when executing certain queries via Java Hibernate while using H2 (1.3.168) as the local database. It appears that the Hibernate attempts to execute a series of SELECT statements but one is failing with a vague error.</p>
  
  <p>The log file reports that a few SELECT statements that do get executed successfully only have a single participating table, e.g. SELECT ... FROM T1 WHERE ...;</p>
  
  <p>However, when it gets to a simple LEFT OUTER JOIN statement in the statement, it produces the following error:</p>
  
  <pre><code>General error: "java.lang.NoClassDefFoundError: org/h2/table/TableFilter$2" [50000-168]
  </code></pre>
  
  <p>I took the exact same query reported by Hibernate and tried to executed it directly in H2 console. Same error.</p>
  
  <p>I replaced LEFT OUTER JOIN with a simple JOIN, same error. I removed the second table from the JOIN and just SELECT from the first table, it SELECTs just fine. Did the same for the second table on its own, no issue, e.g.</p>
  
  <pre><code>SELECT * FROM T1;
  </code></pre>
  
  <p>Tried bunch of other tables with joins... the error reappears.</p>
  
  <pre><code>SELECT * FROM T1 t1 JOIN T2 t2 ON t1.pk_id = t2.fk_id;
  </code></pre>
  
  <p>Does anyone know what the issue is with H2?</p>