title: I kept getting an error that says unknown column film_category.category_id in on clause
body: <p>I've tried doing like this:</p>
  
  <pre><code>select film.title,category.name,category.category_id
  from film
  inner join film_actor on film.film_id= film_actor.film_id
  inner join category on
  film_category.category_id=category.category_id;
  </code></pre>
  
  <p>then I execute it I am getting the error saying </p>
  
  <blockquote>
    <p>unknown column <code>film_category.category_id</code> in on clause</p>
  </blockquote>
  
  <p>.</p>