; With tablename as (..) equivalent in Oracle
<p>I am new to Oracle, and i am trying to replicate a very useful type of query  I always used with SQL Server.</p>

<p>I am trying to find the equivalent in Oracle for this query</p>

<pre><code>; With tablename as (
Select 
Column1 ,
Column2
From table1
) 
, with tablename2 as (
Select 
column3,
Column4
)
Select 
Column 2 ,
column 4
from Tablename t1
left outer join tablename t2
on t1.column1 = t2.column3
</code></pre>