title: selecting rows with id from another table
body: <p>Let's call this table <code>terms_relation</code>:</p>
  
  <pre><code>+---------+----------+-------------+------------+------------+--+
  | term_id | taxonomy | description | created_at | updated_at |  |
  +---------+----------+-------------+------------+------------+--+
  |       1 | categ    | non         | 3434343434 |   34343433 |  |
  |       2 | categ    | non         | 3434343434 | 3434343434 |  |
  |       3 | tag      | non         | 3434343434 | 3434343434 |  |
  |       4 | tag      | non         | 3434343434 | 3434343434 |  |
  +---------+----------+-------------+------------+------------+--+
  </code></pre>
  
  <p>And this is table <code>terms</code>:</p>
  
  <pre><code>+----+-------------+-------------+
  | id |    name     |    slug     |
  +----+-------------+-------------+
  |  1 | hello       | hello       |
  |  2 | how are you | how-are-you |
  |  3 | tutorial    | tutorial    |
  |  4 | the end     | the-end     |
  +----+-------------+-------------+
  </code></pre>
  
  <p>How Do I select all rows in table <code>terms</code> and table <code>terms_relation</code> where it's taxonomy in table <code>terms_relation</code> is <code>categ</code>? Will I need two queries for this or I could use a <code>join</code> statement?</p>