title: What should I do to join 2 tables based on a condition?
body: <p>I want to join 2 tables: <code>book_details</code> and <code>imdb_index</code> of those books whose <code>imdb_index is &gt;=600;</code></p>
  
  <p><a href="https://i.stack.imgur.com/O9x6D.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O9x6D.jpg" alt="enter image description here"></a></p>
  
  <p>Here is what I tried:</p>
  
  <pre><code>select *from imdb_index where imdb_index&gt;=600 as x join book_details as y on x.isbn=y.isbn;
  </code></pre>