title: I want to join tables but still receive results from one table even if the other table has no results
body: <p>I'm doing this in Chrome WebDB/SQLite </p>
  
  <p>I have a members table and an answer table that a member may or may not have answered.</p>
  
  <p>I am TRYING to get back a result set that includes the member name and answer they gave.. BUT if they didnt give an answer, I still want their name to come back.</p>
  
  <p>Can someone try and help me on this?  </p>
  
  <pre><code>SELECT m.LastName, 
         m.FirstName, 
         m.MiddleName, 
         s.surveyAnswer 
  FROM Members m 
      LEFT JOIN SurveyAnswers s 
        ON s.memberID = m.id 
  WHERE m.id = ? 
  AND s.eventID = ? 
  </code></pre>
  
  <p>[results.rows.item(i).memberID, eventId],</p>
  
  <p>This is what I try but still only receive the members who answered a question and is also in the SurveyAnswers table.</p>