title: MySQL: Normalization and Table Join for a Tags Feature
body: <p>My Current Database Structure:</p>
  
  <pre><code>     `images`            `tags`             `images_tags`
   ________________    ______________    ________________________
  | id | title     |  | id | name    |  | id | image_id | tag_id |
  |----|-----------|  |----|---------|  |----|----------|--------|
  |  1 | Ivysaur   |  |  1 | fire    |  |  1 |     2    |    1   | Charizard: fire
  |  2 | Charizard |  |  2 | flying  |  |  2 |     2    |    2   | Charizard: flying
  |  3 | Squirtle  |  |  3 | water   |  |  3 |     1    |    4   |   Ivysaur: grass
  |  4 | Pidgey    |  |  4 | grass   |  |  4 |     4    |    2   |    Pidgey: flying
   ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  </code></pre>
  
  <p>I want to output tags with their respective values (name).</p>
  
  <pre><code>if ($_GET["pokemon"] == "2") {
      // output Charizard's tags: fire, flying
  }
  </code></pre>
  
  <p>But I am struggling at coming up with a proper query to do this. INNER JOIN is unfamiliar to me and an explanation on how it works would be very helpful.</p>