title: SQL SELECT from three tables
body: <p>I have three tables: </p>
  
  <pre><code>Map_table
  - id
  - content_id
  - from_user_id
  - to_user_id
  - timestamp
  
  User_table
  - id
  - name
  
  Content_table
  - id
  - title
  </code></pre>
  
  <p>eg: I want to select rows from the Map_table where Map_table.to_user_id = 1 </p>
  
  <p>and also provide the User_table.name where Map_table.from_user_id = User_table.id</p>
  
  <p>and also provide the Content_table.title where Map_table.content_id = Content_table.id  </p>
  
  <p>Map_table.content_id might be null and therefore not map to the Content_table</p>
  
  <p>If been through a load of answers here and still tearing my hair out to get the results I need.
  Can any SQL gurus out there see a simple solution. The potential JOINs required are frying my brain.</p>
  
  <p>Any help would be much appreciated. For the sake of my scalp, among other things ;)</p>