title: Basic Inner Joins - Understanding
body: <p>I usually learn by seeing examples and working my way backwards.</p>
  
  <p>Can someone help me write out this query:</p>
  
  <p><a href="https://www.sqlteaching.com/#!multiple_joins" rel="nofollow">https://www.sqlteaching.com/#!multiple_joins</a></p>
  
  <p>This is what I wrote, I do not know what I am doing wrong:</p>
  
  <pre><code>SELECT character.name, actor.name
  FROM character 
  INNER JOIN character_tv_show
  ON character.id = character_tv_show.character_id
  INNER JOIN character_actor
  ON actor.id = character_actor.actor_id;
  </code></pre>