title: Joining two tables together with multiple results in one table
body: <p>My tables looks like the following:</p>
  
  <pre><code>tbl_teams
  id, teamname, created
  
  tbl_teamstats
  id, rank, rating, wins, losses, tbl_teams_id, created
  </code></pre>
  
  <p>I want to merge these two tables together based on tbl_teamstats "created desc limit 1"
  for example the query</p>
  
  <pre><code>SELECT TS.*, T.* FROM tbl_teamstats as TS
  LEFT JOIN tbl_teams as T
  ON T.id = TS.tbl_teams_id
  </code></pre>
  
  <p>would return something like this</p>
  
  <pre><code>TS.id   TS.rank TS.rating   TS.wins TS.losses   T.id    T.teamname              T.created
  14871   2       2522        168     26          2       teamname1               23/02/2017 17:55
  14688   2       2540        168     25          2       teamname1               23/02/2017 17:55
  2683    2       2535        167     25          2       teamname1               23/02/2017 17:55
  2612    2       2529        166     25          2       teamname1               23/02/2017 17:55
  2590    2       2523        165     25          2       teamname1               23/02/2017 17:55
  2448    2       2517        164     25          2       teamname1               23/02/2017 17:55
  2346    2       2511        163     25          2       teamname1               23/02/2017 17:55
  234     2       2505        162     25          2       teamname1               23/02/2017 17:55
  1       1       2570        171     19          1       teamname2               23/02/2017 17:55
  </code></pre>
  
  <p>what i want it to look like:</p>
  
  <pre><code>TS.id   TS.rank TS.rating   TS.wins TS.losses   T.id    T.teamname              T.created
  14871   2       2522        168     26          2       teamname1               23/02/2017 17:55
  1       1       2570        171     19          1       teamname1               23/02/2017 17:55
  </code></pre>
  
  <p>(Only showing one result from tbl_teamstat ordered by TS.id)</p>
  
  <p>Could someone please help me or point me in the right direction? Would be greatly appreciated!</p>