title: How to combine multiple tables
body: <p>I have three tables which I want to combine into one view or temporary table, they are a pupil table:  </p>
  
  <pre><code>| id | UPN |   
  </code></pre>
  
  <p>A snapshot table:</p>
  
  <pre><code>| id | PupilID | Surname | Forename | AssessmentYr |  
  </code></pre>
  
  <p>A results table:</p>
  
  <pre><code>|  id |  PupilID  | KS1RdTA |  KS1WrTA |  
  </code></pre>
  
  <p>The id in the pupil table matches with PupilID in the snapshot and results, in the snapshot table there may be more than one entry with the same PupilID.</p>
  
  <p>There may not be any match in either the pupil or results table.</p>
  
  <p>My question is how to write a query which will take every entry in the snapshot table, regardless of whether it is matched with anything in the pupil or results table, but, where possible, match it up.</p>
  
  <p>I want to either make this into a temporary table or a view for subsequent manipulation and would welcome some suggestions on which would work best.</p>
  
  <p>Thanks in advance for your help.</p>