title: ERROR: missing FROM-clause entry for table "director" LINE 2: JOIN directors d ON mo.director.id = d.director.id (BEGINNER LEVEL)
body: <pre><code>SELECT mo.movie_name,d.first_name,d.last_names FROM movies mo
  JOIN directors d ON mo.director.id = d.director.id
  WHERE mo.movie_id IN 
  (SELECT movie_id FROM movie_revenues
  WHERE international_takings &gt; domestic_takings);
  </code></pre>
  <p>Following a tutorial on Udemy and keep getting this
  Error: missing FROM-clause entry for table &quot;director&quot;
  LINE 2: JOIN directors d ON mo.director.id = d.director.id</p>
  <p>I have used the exact same syntax and punctation as a video tutorial I get. I also got the same error message when referencing the director table in an earlier query, although I dont understand where the error lies?</p>