title: MySQL How can I make a better query to connect two tables through my bridge table?
body: <p>I have these tables:</p>
  
  <p>words:</p>
  
  <pre><code>+----+------+
  | ID | DATA |
  +----+------+
  |  1 | jo   |
  |  2 | yes  |
  |  3 | jupp |
  |  4 | yeah |
  |  5 | jepp |
  |  6 | joah |
  |  7 | ne   |
  |  8 | nee  |
  |  9 | no   |
  | 10 | nope |
  | 11 | nah  |
  +----+------+
  </code></pre>
  
  <p>statements:</p>
  
  <pre><code>+----+------+
  | ID | DATA |
  +----+------+
  |  1 | ja   |
  |  2 | nein |
  +----+------+
  </code></pre>
  
  <p>and a bridge table that connects the words from table "words" with the DATA from table "statements":</p>
  
  <p>bridge:</p>
  
  <pre><code>+--------------+---------+
  | ID_statement | ID_word |
  +--------------+---------+
  |            1 |       1 |
  |            1 |       2 |
  |            1 |       3 |
  |            1 |       4 |
  |            1 |       6 |
  |            2 |       8 |
  |            2 |       9 |
  +--------------+---------+
  </code></pre>
  
  <p>I wanted to get a SELECT QUERY to get all words associated with the statement "ja".</p>
  
  <p>this query does the job, but seems more complicated than it should be:</p>
  
  <pre><code>SELECT words.DATA FROM words 
   JOIN bridge ON words.ID = bridge.ID_word 
   JOIN statements ON statements.ID = bridge.ID_statement 
   WHERE statements.ID = (
   SELECT ID FROM statements WHERE statements.DATA = "ja"
   );
  </code></pre>
  
  <p>Intuition tells me that I am doing that far to comlicated, but I can't figure out where the complication lies.
  awkward.</p>