title: SQL join two tables where IDs match
body: <p>I have two tables in my database.</p>
  
  <p><code>Movies</code> table:</p>
  
  <pre class="lang-none prettyprint-override"><code>+----------------------------------------
  | ID | title                | timestamp |
  +----------------------------------------
  | 1  | The host             | time      |
  | 2  | Fight Club           | time      |
  | 4  | 21                   | time      |
  ----------------------------------------+
  </code></pre>
  
  <p><code>Movie_Links</code> table:</p>
  
  <pre class="lang-none prettyprint-override"><code>+---------------------------------------+
  | ID | link                 | movie_id  |
  +---------------------------------------+
  | 1  | some link            | 1         |
  | 2  | some link            | 1         |
  | 3  | some link            | 1         |
  +---------------------------------------+
  </code></pre>
  
  <p>At the moment I am only selecting the rows from the <code>Movies</code> table where the <code>title</code> is like for example:</p>
  
  <pre><code>SELECT * FROM `Movies` 
  WHERE `title` LIKE '%The Host%' 
  ORDER BY `timestamp` DESC DESC LIMIT 30
  </code></pre>
  
  <p>But what I want to do is the same query as above but join <code>Movie_Links</code> table where <code>movie_id</code> equals <code>Movies</code> table's <code>ID</code> and get all links that have a <code>Movie_id</code> equal to <code>1</code>.</p>