title: Mixing "USING" and "ON" in Oracle ANSI join
body: <p>I wrote an Oracle SQL expression like this:</p>
  
  <pre><code>SELECT
  ...
  FROM mc_current_view a
  JOIN account_master am USING (account_no)
  JOIN account_master am_loan ON (am.account_no = am_loan.parent_account_no)
  JOIN ml_client_account mca USING (account_no)
  </code></pre>
  
  <p>When I try to run it, Oracle throws an error in the line with "ON" self-join saying: "ORA-25154: column part of USING clause cannot have qualifier".</p>
  
  <p>If I omit the "am" qualifier, it says: "ORA-00918: column ambiguously defined".</p>
  
  <p>What's the best way to resolve this?</p>