title: SQL get user.emails from user_id list
body: <p>I am trying to do a simple SQL query but am struggling to get it right. </p>
  
  <p>I have a table called trips, that has a created_at column, as well as a user_id column (among other things). </p>
  
  <p>I also have users table with names and emails.</p>
  
  <p>I am trying to get a list of user names and emails that have posted a trip in the last 12 months.</p>
  
  <p>I have written this query so far:</p>
  
  <pre><code>SELECT `user_id` 
  FROM `trips`
  WHERE trips.created_at &gt; '2014-03-01 00:00:00'
  </code></pre>
  
  <p>Which gives me the user_id for the users that have created a trip in the last 12 months, but I don't know how to extend it so it gives me their name and emails from the user table.</p>