title: Join two tables with one table has multiple rows matching
body: <p>Trying to figure out if it is possible to create a query where you join tables, table one is smaller than table two, table two has multiple references matching table one entries, the query would output a joining where table one length is preserved but you just add more columns. Not sure if that makes sense so here is a example of what I am after </p>
  
  <pre><code>Table One                                  Table two
  +-----------------------------+           +-----------------------------+
  | id | english  |  definition |           | id | word_id  |  sentence   |
  +-----------------------------+           +-----------------------------+
  |1   |    A1    |    blah     |           |1   |    1    |   blahblah1  |
  |2   |    B4    |    blah2    |           |2   |    1    |   blahblah2  |
  +-----------------------------+           |3   |    1    |   blahblah3  |
                                            |4   |    2    |   blahblah4  |
                                            |5   |    2    |   blahblah5  |
                                            +-----------------------------+
  </code></pre>
  
  <p>********* Query should return something like *****************</p>
  
  <pre><code>+----------------------------------------------------------------+
  | id | english  |  definition | sentence | sentence2 | sentence3 | 
  +----------------------------------------------------------------+
  |1   |    A1    |    blah     | blahblah1|  blahblah2| blahblah3 |
  |2   |    B4    |    blah2    | blahblah4|  blahblah5|           |
  +----------------------------------------------------------------+
  </code></pre>
  
  <p>My Current query looks like this and results in:</p>
  
  <pre><code>$query = "SELECT * FROM T1 INNER JOIN T2 ON T1.id = T2.word_id";
  </code></pre>
  
  <p>Resulting in:</p>
  
  <pre><code>+----------------------------------------+
  | id | english  |  definition | sentence |
  +----------------------------------------+
  |1   |    A1    |    blah     | blahblah1|
  |1   |    A1    |    blah     | blahblah2|
  |1   |    A1    |    blah     | blahblah3| 
  |2   |    B4    |    blah2    | blahblah4|
  |2   |    B4    |    blah2    | blahblah5|
  +----------------------------------------+
  </code></pre>
  
  <p>I am working with PHP and MySql. </p>
  
  <p>UPDATE!!</p>
  
  <p>Staying with my original query and manipulating the results with PHP getting good performance too. Let me know if you need me to post my code. </p>