title: SQL one to many with inner join
body: <p>Say I have two tables, table 1 and table 2. Table 1 has a one to many relationship with table 2.</p>
  
  <p>If table 1 is my base table (<code>SELECT something FROM table1</code>) with an inner join to table 2, then what values from table two would be returned when selecting any fields from table 2?</p>
  
  <ul>
  <li>The first value returned? As with excel's vlookup function? </li>
  <li>The last value on the join?</li>
  </ul>
  
  <p>E.G. </p>
  
  <pre><code>Table1
       Account ID |      email      
           1      |   abc@def.com
           2      |   cats@dogs.com
           3      |   ex@example.com
  
  Table 2
  Subscription ID | Account ID  |       Email       |      Created
      100         |     1       |    abc@def.com    |    2014-01-01
      102         |     2       |    cats@dogs.com  |    2014-02-02
      103         |     1       |    abc@def.com    |    2014-03-03
  </code></pre>
  
  <p>So if I ran a query to select the created date of an account based on subscriptions I could just run <code>SELECT min(Created)</code> to get the first one.</p>
  
  <p>But what's the default behavior? If my left table is table 1 joined onto table 2 on account ID and I select created field, which will be returned? 2014-01-01 or 2014-03-03?</p>