title: Need help in improving the query
body: <p>I get an error </p>
  
  <blockquote>
    <p>"Invalid operation: table name "ball.songcollection" specified more than once;
    1 statement failed." </p>
  </blockquote>
  
  <p>do you know why this is? I'm new to SQL and trying to learn.</p>
  
  <pre><code>SELECT ball.songcollection.artist_name,
         ball.songcollection.songname,
         ball.performance.rank,
         ball.performance.genre
  
  FROM   ball.songcollection, ball.performance
  INNER JOIN ball.songcollection ON ball.songcollection.id=ball.performance.ball_id
  </code></pre>