title: ORA-32033: unsupported column aliasing : Oracle 10g
body: <p>I am new in SQL . When I am going to use this query , it occurs error . Here is my query :</p>
  
  <pre><code>with new_table ( loan, customer_city ) as 
  (
   select l.loan_number , c.customer_name, customer_city 
     from loan l
     join borrower b on b.loan_number = l.loan_number 
     join customer c on c.customer_name = b.customer_name
    order by loan_number 
  )
  select customer_city 
    from new_table;
  </code></pre>