title: Alias not working in inner join
body: <p>I'm trying to give an alias to the table facturation and to the table member in the inner join so I can use it in the sub query in the select like this</p>
  
  <pre><code>    SELECT description,
         Avg((SELECT Count(*)
              FROM   facturation F
              WHERE  F.membreid = M.membreid))
  FROM   v_type_membre
         INNER JOIN v_membre M
                 ON v_type_membre.typeid = M.typeid
         INNER JOIN v_facturation
                 ON M.membreid = v_facturation.membreid
  GROUP  BY description
  ORDER  BY description; 
  </code></pre>
  
  <p>Why do I get the error :</p>
  
  <pre><code>Error at Command Line:3 Column:31
  Error report:
  SQL Error: ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Thank you</p>