title: MySQL: How to Select All Results That Don't Match LEFT JOIN
body: <p>My SELECT statement is essentially:</p>
  
  <pre><code>SELECT *, user.user, response.survey FROM survey, user, response ORDER BY survey.added
  </code></pre>
  
  <p>However, I am trying to select only surveys that haven't been answered.  The 'response' table contains 4 relevant columns (user ID [of user responding to survey], answer, question [same as survey ID if single question, if multi, corresponds to question ID], and survey ID)</p>
  
  <p>I'm trying to write an SQL statement that selects all surveys that don't have a response from an arbitrary user ID ($_SESSION['userId'])... Tried going about this using various LEFT JOIN as well as nested SELECT commands, but haven't been able to figure it out.</p>
  
  <p>Can anyone shed some light on how to go about this?</p>