title: Retrieving All records - Inner join
body: <p>I'm a bit of a database novice, so pardon my naivety here.
  I have following sql statement:</p>
  
  <pre><code>SELECT DISTINCT  dbo.tb_user.familyName,
  dbo.user_email.email FROM dbo.tb_user  
  INNER JOIN dbo.user_email ON (dbo.tb_user.id = dbo.user_email.userID)
  </code></pre>
  
  <p>This returns records where an email address exists.</p>
  
  <p>What I would like to do is retrieve all the records so I can see which users do and do not have email address/es recorded in the db.</p>
  
  <p>Can this be achieved?</p>
  
  <p>Any hints/help much appreciated.</p>