title: Natural join of 3 tables in mysql
body: <p>So i have 3 tables, movies(contains columns id and name), directors(id, first_name, last_name) and movies_directors(movie_id and director_id). I want to combine these 3 tables, since they have same values(director_id and movie_id) and then project specific columns. Thats what i did so far:</p>
  
  <pre><code>select first_name, last_name, name 
  from movies natural join directors natural join movies_directors 
  where movies_directors.movie_id=movies.id and  
  movies_directors.director_id=directors.id; 
  </code></pre>
  
  <p>However, the table that is produced in the end is empty! I have aslo tried to use views, and it works with either 2 tables(it returns the combined table) but when it comes to the third one the table returned is empty.</p>