title: How to use "as" to set alias for joined tables in oracle 10
body: <p>I wrote this, and it is wrong syntax, help me fix it, I want 'T' to be an alias of the result of the two inner joins.</p>
  
  <pre><code>select T.id 
  from table1 
    inner join table2 on table1.x = table2.y  
    inner join table3 on table3.z = table1.w as T;
  </code></pre>