title: ORA-00918: column ambiguously defined in SELECT *
body: <p>Getting ORA-00918: column ambiguously defined: running this SQL:</p>
  
  <pre><code>SELECT *
  FROM
    (SELECT DISTINCT(coaches.id),
      people.*,
      users.*,
      coaches.*
    FROM "COACHES"
    INNER JOIN people ON people.id = coaches.person_id
    INNER JOIN users ON coaches.person_id = users.person_id
    LEFT OUTER JOIN organizations_users ON organizations_users.user_id = users.id
  ) WHERE rownum &lt;= 25
  </code></pre>
  
  <p>Any suggestions please?</p>