title: Limiting a left join to returning one result?
body: <p>I currently have this left join as part of a query:</p>
  
  <pre><code>LEFT JOIN movies t3 ON t1.movie_id = t3.movie_id AND t3.popularity = 0
  </code></pre>
  
  <p>The trouble is that if there are several movies with the same name and same popularity (don't ask, it just is that way :-) ) then duplicate results are returned.</p>
  
  <p>All that to say, I would like to limit the result of the left join to one. </p>
  
  <p>I tried this:</p>
  
  <pre><code>LEFT JOIN 
      (SELECT t3.movie_name FROM movies t3 WHERE t3.popularity = 0 LIMIT 1)
       ON t1.movie_id = t3.movie_id AND t3.popularity = 0
  </code></pre>
  
  <p>The second query dies with the error:</p>
  
  <pre><code>Every derived table must have its own alias
  </code></pre>
  
  <p>I know what I'm asking is slightly vague since I'm not providing the full query, but is what I'm asking generally possible?</p>