title: WITH AS in oracle query
body: <p>What if I have different tables on my oracle query, how can I group them in one <code>WITH AS</code> query:</p>
  
  <pre><code>WITH A AS (
                  SELECT A,B FROM TABLE1,
                  SELECT C FROM TABLE2 ---&gt; ??
       )
  </code></pre>
  
  <p>I want to translate my query with "with as" function including different tables. but it seems selecting another column form other table is not working.</p>
  
  <pre><code>Table1
  A             B
  data1        data1
  
  
  
  Table2 
  C
  Data1
  </code></pre>
  
  <p>i just want to query them into one "With AS" statement. :)</p>
  
  <p>output should be</p>
  
  <pre><code>A            B          C
  data1       data1     data1
  </code></pre>