title: Query with multiple common table expressions not working?
body: <p>If I use two common table expressions, one is recursive and one is simple it's not working. If both are simple it's working (it's in HSQL, and Postgres syntax is working)</p>
  
  <p>NOT WORKING</p>
  
  <pre><code>WITH RECURSIVE TEMP_TABLE1(NAME) AS 
  (
      SELECT child FROM FAMILY where parent='HUMAUN'
      UNION
      SELECT CHILD FROM FAMILY,TEMP_TABLE WHERE PARENT=TEMP_TABLE.NAME
  ),
  TEMP_TABLE2 AS 
  (
       SELECT CHILD FROM FAMILY
  )
     SELECT CHILD FROM TEMP_TABLE1,TEMP_TABLE2 
     WHERE TEMP_TABLE1.NAME=TEMP_TABLE2.NAME 
  </code></pre>
  
  <p>Working if I make temp_table1 to a simple non recursive </p>
  
  <pre><code>WITH TEMP_TABLE1(NAME) AS 
  (
      SELECT child FROM FAMILY where parent='HUMAUN'
      UNION
      SELECT CHILD FROM FAMILY WHERE PARENT='XYZ'
  ),
  TEMP_TABLE2(NAME) AS 
  (
       SELECT CHILD FROM FAMILY
  )
     SELECT NAME FROM TEMP_TABLE1,TEMP_TABLE2 
     WHERE TEMP_TABLE1.NAME=TEMP_TABLE2.NAME 
  </code></pre>